How many days have elapsed since the Declaration of Independence, July 4, 1776? If you are trying to calculate day differences for dates before January 1, 1900, you are out of luck using Excel. How many days have elapsed since October 28, 1492, the day that (supposedly) Columbus discovered Cuba? Excel can't tell you. Somewhere back in the 16th century most of the western world switched from the Julian calendar to the Gregorian calendar.
How many days have elapsed since the Declaration of Independence, July 4, 1776? If you are trying to calculate day differences for dates before January 1, 1900, you are out of luck using Excel.
How many days have elapsed since October 28, 1492, the day that (supposedly) Columbus discovered Cuba? Excel can't tell you. Somewhere back in the 16th century most of the western world switched from the Julian calendar to the Gregorian calendar.