ExcelBanter - Elapsed period between dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Elapsed period between dates (https://www.excelbanter.com/excel-programming/402651-re-elapsed-period-between-dates.html)

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

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