Dates earlier than 1900
 

As an historian, I must calculate dates prior to 1900, but Excel 2000 only
permits pre-defined calculations from January 1, 1900 and later. How do I
calculate the days between October 10, 1836 and December 14, 1917?

http://j-walk.com/ss/excel/files/xdate.htm

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"tbng" wrote in message
...
As an historian, I must calculate dates prior to 1900, but Excel 2000 only
permits pre-defined calculations from January 1, 1900 and later. How do I
calculate the days between October 10, 1836 and December 14, 1917?

tbng, have a look here,

http://j-walk.com/ss/excel/usertips/tip028.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"tbng" wrote in message
...
As an historian, I must calculate dates prior to 1900, but Excel 2000 only
permits pre-defined calculations from January 1, 1900 and later. How do I
calculate the days between October 10, 1836 and December 14, 1917?