Wednesday, January 4, 2012

Day of Week Formula for Excel

If you have an Excel spreadsheet and one cell has the date in mm/dd/yyyy format.  And let's say you would like the adjacent cell to display the Day of the week for that Date.  You can use the following formula to make this happen:

=TEXT(WEEKDAY(A3), "ddd")

A3 refers to the cell that has the Date (mm/dd/yyyy) and "ddd" show the Day in a 3 character format.  If you change the formula to "dddd" the Day of the week will be completely spelled out.


No comments:

Post a Comment