Does anyone have any ideas on how to derive the day of the week for a
list of pre-1900 dates, each of which is presented in a three cell
horizontal format YEAR MONTH DAY, ie 1685 March 21.
I have a spreadsheet with over 1300 lines in this format, so any
function or calculation that can be entered into a blank cell on each
line to get the actual day for that line is the preferred solution.
Thanks in advance.
--
ddmac
------------------------------------------------------------------------
ddmac's Profile:
http://www.excelforum.com/member.php...o&userid=36185
View this thread:
http://www.excelforum.com/showthread...hreadid=559593