Is there any way to get Excel to accept dates prior to 1900 as a date for use in a calculation.
R red-john Sep 5, 2006 #1 Is there any way to get Excel to accept dates prior to 1900 as a date for use in a calculation.
D Dave Peterson Sep 5, 2006 #2 Not directly. But John Walkenbach shares an addin that can help: http://j-walk.com/ss/excel/files/xdate.htm
Not directly. But John Walkenbach shares an addin that can help: http://j-walk.com/ss/excel/files/xdate.htm
