How do I Modify Julian calendar restriction of 1900

S

SAPOMAN

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate age using a 12 digit social security number in MS Excel? 0
How do I find age in years from anniversary date (Age funtion)? 1
How do I calculate age from birthdate to present in Excel? 4
How do I plot "Month, Year" on the x-axis for prior to 1900? 2
How do I convert a Julian date into a regular date? 4
How do I calculate age using dates in Excel? 2
How do I create a formula in excel to multiply two items from two 2
How do I count the number of events in a 90 day period? 2

Top