Dates prior to 1900 are text

[xp]

Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
are not formatted as dates, but seem to become text. I can't do calculations
between such dates...what gives?

Anyone know how to over come this horrible limitation?

 

[Dave Peterson]

John Walkenbach has an addin that may help you:
http://j-walk.com/ss/excel/files/xdate.htm

 

[Gary''s Student]

see:

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

 

[Autor]

You need to treat that dates as numbers and at the end present the result as
a text that looks like a date.