Day Of The Week

[lsmft]

Does Excel have the ability to show the day of the week for dates of
long past?
Example:
If I were to type into a cell the date 04/21/1949, can Excel show the
day of the week that 04/21/1949 fell on?
Thank you for your help!!

 

[Niek Otten]

Yes.

Just type the date as an Excel date (like 04/21/1949 and choose one of the
date formats in the format menu to get for example

Thursday, April 21, 1949

 

[daddylonglegs]

As long as your date is on or after 01/01/1900 (although Excel gives the
wrong day of the week up to 28th Feb 1900 because it treats 1900 as leap
year)

You can simply format your date as

ddd

or use a formula in another cell

=TEXT(A1,"ddd")

where your date is in A1

 

[dominicb]

Good evening Ismft

You can indeed check the days of "long gone" dates, but only so far
back.
You could enter 21/04/1949 in a cell and change the format to custom
"dddd" (without quotes) to give Thursday. Or use a formula if you
prefer, eg., =TEXT(A1,"ddd") which would return Thu (use "dddd" to
return Thursday).

However, this will only go accurately back as far as February 28 1900.
Excel was programmed to count 1900 as a leap year when it wasn't. This
was done deliberately to ensure compatability with 1-2-3 which made the
error originally.

HTH

DominicB

 

[lsmft]

Thank y'all very much, as your suggestion works just fine.
I do appreciate your help.
Have a nice evening now!!