Link date to Day of week

Microsoft Office excel 2007 home & stude...
June 14, 2010 at 12:36:43
Specs: Windows 11.07.2009
How do I link a date so that when I type the date in that it comes up as a day of the week. Example: If i type 06/14/2010, I want it to come up as Monday.

See More: Link date to Day of week

Report •

#1
June 14, 2010 at 12:47:26
With your date in A1, try:

=TEXT(A1,"ddd") to get Mon

or

=TEXT(A1,"dddd") to get Monday


Report •

#2
June 14, 2010 at 12:51:19
Thank you that worked.

Report •

#3
June 14, 2010 at 12:52:23
Anytime...

Report •
Related Solutions


Ask Question