Article View: comp.sys.mac.apps
Article #7624Excel dates: 1904 vs 1900
From: Sue Klefstad
Date: Wed, 06 Mar 1991 21:49
Date: Wed, 06 Mar 1991 21:49
22 lines
1256 bytes
1256 bytes
When we export data from an Excel spreadsheet into another program, say FileMaker, the dates are changed to 4 years and 1 day earlier. Okay, I've found the Excel Options Calculation check box that puts Excel dates into the 1900 format that I take it all other programs are looking for. So now the Excel spreadsheet's existing dates are changed to 4 years and 1 day earlier. I need to correct these existing dates but cannot figure out how to add a day and four years to a date. Can someone please help? Yes, I've RTFM'd but the FM only says its possible and refers me to Sampler, which I take it must be a manual that no longer exists here. Thank you! -- -- Sue -- ========================================================================= Sue Klefstad Ill. Natural History Survey klefstad@uiuc.edu
Technical Details
Message-ID:
<1991Mar6.214939.5411@ux1.cso.uiuc.edu>Path:
arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uwm.edu!ux1.cso.uiuc.edu!klefstadShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uwm.edu!ux1.cso.uiuc.edu!klefstad From: klefstad@ux1.cso.uiuc.edu (Sue Klefstad) Newsgroups: comp.sys.mac.apps Subject: Excel dates: 1904 vs 1900 Message-ID: <1991Mar6.214939.5411@ux1.cso.uiuc.edu> Date: 6 Mar 91 21:49:39 GMT Sender: klefstad@ux1.cso.uiuc.edu (Sue Klefstad) Distribution: na Organization: University of Illinois at Urbana Lines: 22