Do you have some samples of the dates? For example, on row 1 were date1
through date5 all originally (input - SMODT) the same date? Or were they
significantly different?
There are some strange quirks in MS in converting dates. For example the
year 1900 was not a leap year (only '00 years that are divisible by 400,
like 2000, are). Yet if you set an Excel cell to
= date(00,02,25)
and set the cell below it to
=A1+1
and copy it down so you have
=A2+1
=A3+1
and so on you will see 2/29/1900 which is an erroneous date. It's a bug
they carried over from Lotus 123 so they could be migration compatible.
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
