View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luciano[_2_] Luciano[_2_] is offline
external usenet poster
 
Posts: 30
Default 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