ExcelBanter - How do I Modify Julian calendar restriction of 1900

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I Modify Julian calendar restriction of 1900 (https://www.excelbanter.com/excel-worksheet-functions/251940-how-do-i-modify-julian-calendar-restriction-1900-a.html)

SAPOMAN

How do I Modify Julian calendar restriction of 1900

Am working on family tree with many born dates prior to 1900 and death dates
after 1900. Can't write formula to calculate age because of pre-1900
birthdate. Excel doesn't record a Julian number on the dates earlier than
1900. Is there a workaround?

Glenn

How do I Modify Julian calendar restriction of 1900

SAPOMAN wrote:
Am working on family tree with many born dates prior to 1900 and death dates
after 1900. Can't write formula to calculate age because of pre-1900
birthdate. Excel doesn't record a Julian number on the dates earlier than
1900. Is there a workaround?

A little searching yielded this:

http://www.j-walk.com/ss/excel/files/xdate.htm

Gary''s Student

How do I Modify Julian calendar restriction of 1900

http://j-walk.com/ss/excel/files/xdate.htm
--
Gary''s Student - gsnu200909

"SAPOMAN" wrote:

Am working on family tree with many born dates prior to 1900 and death dates
after 1900. Can't write formula to calculate age because of pre-1900
birthdate. Excel doesn't record a Julian number on the dates earlier than
1900. Is there a workaround?

All times are GMT +1. The time now is 06:54 PM.