Microsoft Excel 'Quick Tip'
Previously published in my "Spreadsheet Tips From An Excel Addict" newsletter
Get The Day Of The Week From A DateLet's say you have a date 22-Sep-08 in cell A1 and you want to determine the day of the week.
WEEKDAY(A1) will evaluate to 2, and CHOOSE will find the 2nd item in the list.
Assuming that the date in cell A1 is 22-Sep-08. In another cell, enter =TEXT(A1,"ddd") and you will get "Fri". If you enter =TEXT(A1,"dddd") you will get "Monday"
Why not print (CTRL+P) this tip and
share it with your friends and associates?