Entering dates in Excel 2002
Is it possible to enter and use dates prior to January 1,1900, in
calucaltaions in Excel 2002. Specifically trying to calculate the number of days between two dates where one or both of the dates are prior to January 1, 1900. If so how? |
On Sat, 8 Jan 2005 21:27:01 -0800, "DickG"
wrote: Is it possible to enter and use dates prior to January 1,1900, in calucaltaions in Excel 2002. Specifically trying to calculate the number of days between two dates where one or both of the dates are prior to January 1, 1900. If so how? You would need to use a VBA routine for this (or write some complex string-parsing formulas). Excel by itself does not recognize dates prior to 1900. What is your potential date range? --ron |
Dick
From Help in XL2003 Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used) Latest date allowed for calculation December 31, 9999 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "DickG" wrote in message ... Is it possible to enter and use dates prior to January 1,1900, in calucaltaions in Excel 2002. Specifically trying to calculate the number of days between two dates where one or both of the dates are prior to January 1, 1900. If so how? |
John Walkenbach created an addin that allows you to work with dates before 1900.
You can find it he http://j-walk.com/ss/excel/files/xdate.htm DickG wrote: Is it possible to enter and use dates prior to January 1,1900, in calucaltaions in Excel 2002. Specifically trying to calculate the number of days between two dates where one or both of the dates are prior to January 1, 1900. If so how? -- Dave Peterson |
All times are GMT +1. The time now is 07:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com