Subtracting AD and/or BC dates
Dear all,
I need to be able to calculate the number of days between two dates (and I have thousands of dates). Both dates may be a BC or AD date or one date will be a BC date and the other and AD date. In addition, the dates are in Excel columns in a particular format as following examples:
Examples
-1898-Jan-23
-1898-Jul-18
-1898-Dec-14
2001-Feb-13
2001-Aug-09
2002-Feb-03
Thanks for the help.
Luciano
|