MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Ron on August 21, 2001 6:57 AM

Can anyone tell me what the Tools|Options 1904 Date System does?

Posted by Mark W. on August 21, 2001 7:09 AM

See the Excel Help topic for "How Microsoft Excel
performs date and time calculations". And under-
stand that Excel was originally written for the
Macintosh which is based on the 1904 date sytem.
It wasn't until Excel was ported to Windows
that the 1900 date system option was necessary.