Excel 2010 - Date arithmetic BEFORE 1900 (1774 up to 1900)
I need to compute the number of days/months/years on a group of dates from 1700 to 1900. I've got about 100 dates I need to compute durations on.
How can I do this?
Example: October 7, 1779 to January 13, 1800
How many days/months/years.