Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date calculations before 1900 do not work
I'm using dates prior to 1900 in my history research and needing to do
calculations. Excel Functions like YEAR do not work with these early dates. Is there a fix for this or a way around the problem. Many thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
How do I enter a date before 1900 in excel? | Excel Worksheet Functions | |||
Date and time calculations | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |