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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=516374