| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Elapsed period between dates
You can take a look at these sites. Maybe they will help.
http://j-walk.com/ss/excel/files/xdate.htm http://support.microsoft.com/kb/214058 "Robin Clay" wrote: Greetings ! Excel will give the number of days between two given dates, provided both are post 1/1/1900. For Family History research, I would like to obtain the time between dates for periods going back to the 1600s ! e.g., I would like to interogate my database to find the ages at marriage of my ancestors. O.K, I guess to the nearest month would be accurate enough ! Regards Robin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Elapsed period between dates
Thank you for your help.
-- Regards Robin "JLGWhiz" wrote: You can take a look at these sites. Maybe they will help. http://j-walk.com/ss/excel/files/xdate.htm http://support.microsoft.com/kb/214058 "Robin Clay" wrote: Greetings ! Excel will give the number of days between two given dates, provided both are post 1/1/1900. For Family History research, I would like to obtain the time between dates for periods going back to the 1600s ! e.g., I would like to interogate my database to find the ages at marriage of my ancestors. O.K, I guess to the nearest month would be accurate enough ! Regards Robin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Elapsed Time Over a Set Period | Excel Worksheet Functions | |||
| Elapsed dates help needed | Excel Discussion (Misc queries) | |||
| Formula to calculate elapsed dates. | Excel Discussion (Misc queries) | |||
| dates count till elapsed | Excel Discussion (Misc queries) | |||
| Determine elapsed time between two dates | Excel Programming | |||
Hybrid Mode
