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

New computer, how do i move outlook 365 ENTIRELY? 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 get my Outlook calendar to show Julian dates? 1
How do I create a formula in excel to multiply two items from two 3
How do I calculate ones age as of todays date? 4
How do I count the number of events in a 90 day period? 2

Top