Thread
:
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
Another way:
A1 = 1/1/2007
=TEXT(A1,"ddd") returns Mon
=TEXT(A1,"dddd") returns Monday
Biff
"GRE" wrote in message
...
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)