Note also that Excel does not do dates correctly if they're prior to 1 Jan 1900. For earlier dates, one can enter them in the normal way, and they'll appear correct, but they will be text entries, not values, and calculations using them will produce an error. Rick Van Dusen On 9/26/2015 3:31 AM, Graeme Simpson via wrote: : : : > As for using Microsoft products to calculate dates be aware that > Excel thinks 1900 was a leap year unless you use an add-in to correct > that. I can't comment on other their products as I haven't used them > for date calculations. > > Graeme Simpson

At 9/26/2015 11:28, you wrote: >Note also that Excel does not do dates correctly if they're prior to 1 >Jan 1900. For earlier dates, one can enter them in the normal way, and >they'll appear correct, but they will be text entries, not values, and >calculations using them will produce an error. There are Extended Date Function add-ins for Excel that will provide for dates before 1 Jan 1900. These are almost as simple to use as regular date functions for most purposes. Lee