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?

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

xp wrote:
>
> 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

see:

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


--
Gary''s Student - gsnu201001


"xp" wrote:

> 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?
>
>
>

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


"xp" wrote:

> 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?
>
>
>