MrExcel Publishing
Your One Stop for Excel Tips & Solutions

1904 Date System

Posted by Mudface on October 18, 2001 1:23 AM

Argghhh, I've just finished off flexi-time sheets for several of our departments containing a myriad of formulas to correctly display negative times, when I find I could have used the 1904 date system to do it much more easily.

Before I go and re-do all the sheets, though, I have a couple of questions-

1. If I check 1904 in the options, will it stay checked when used by other people on different PC's (ie it won't revert back to the 'normal' date system)?

2. Will checking 1904 change other people's settings when using other 'normal' Excel sheets (ie will these sheets be changed to 1904, also)?

Thanks for any help you can offer. Bloody Excel :).

Posted by Mark W. on October 18, 2001 2:07 PM

Just to set the record straight...

The 1904 system isn't any less "normal" than 1900.
If fact, 1904 is the original date system... when
a Windows-based PC was still a Bill Gates dream.