On Fri, 08 Jul 2005 07:06:14 -0400, StargateFan
wrote:

On Fri, 08 Jul 2005 06:57:49 -0400, StargateFan
wrote:

On Thu, 07 Jul 2005 21:45:35 -0400, Ron Rosenfeld
wrote:

On Thu, 07 Jul 2005 21:30:00 -0400, StargateFan
wrote:


[snip]

When you switch to the 1904 system, be aware that any dates in your workbook
will be shifted by four years.

[snip]

Thanks so much! The dates I put in do indeed show 2009 instead of
2005 but I'll figure out how to subtract 4 years from the display.

<lol Duh, it changed the dates I'd typed in to 2009 when I intially
changed the workbook to the 1904 date system but all I had to do was
just type in 2005 again! <g I tested the rest of the sheet manually
by adding in other dates as per normal but the correct date is still
displayed. So everything's okay.

I'm guessing that what happens here is that if any date calculations
are done in formulas anywhere else from here on in, that the dates may
be off by 4 years (?). In my case, there are no date calculations at
all, just time ones, so just making sure the dates displayed are
always of the current year should be enough.

Thanks! :oD

Excel stores dates as serial numbers. In the 1900 date system, day 1 is 1 Jan
1900. In the 1904 date system, day 1 is 2 Jan 1904 (day 0 is 1 Jan 1904).

So when you change systems, the serial number does not change -- that is why
you see the 4 year (and 1 day) jump in dates.

When you enter a new date, the proper serial number for that date gets entered.

When you typed in the 2005 date, Excel assigned a serial number that differed
by 1462 from the original.

HTH and glad you've got things working OK for you.


--ron