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!!
Sorry, I forgot to mention that I had tried using the "Date" format in Excel as well as the "Custom" format, but to no avail.

[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

[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


--
Kind regards,

Niek Otten



"lsmft" <[email protected]> wrote in
message news:[email protected]...
>
> 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!!
>
>
> --
> lsmft
> ------------------------------------------------------------------------
> lsmft's Profile:
> http://www.excelforum.com/member.php...o&userid=30678
> View this thread: http://www.excelforum.com/showthread...hreadid=516374
>

[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!!