Get The Day Of The Week From A Date
Have you ever needed in Excel to populate the day of week in a separate column? Two easy ways:
Method 1:
=TEXT(WEEKDAY(A2),"dddd")
Method 2:
=CHOOSE(WEEKDAY(A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
4.05.2012
Have you ever needed in Excel to populate the day of week in a separate column? Two easy ways:
Method 1:
Method 2:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Any anonymous comments with links will be rejected. Please do not comment off-topic