Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get Excel 2003 to display dates before 1900 | Excel Discussion (Misc queries) | |||
How do I replace dates earlier than certain date? | Excel Discussion (Misc queries) | |||
graph dates revert to 1900 | Charts and Charting in Excel | |||
Dates before 1900 | Excel Worksheet Functions | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) |