klefstad@ux1.cso.uiuc.edu (Sue Klefstad) (03/07/91)
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