date system

T

The Rook

I currenlty have an ODBC link into a database, when a date is extracted it is
imported as a serial number, the problem is that the data base does not use
the 1900 of 1904 system.

Todays date 15/03/2007 is imported as 732750
in excel 732750 formatted into a date if 14/03/3906

Is there an easy way to change this in excel so that it formates to the date
I require?

regards
 
M

Mike

Whatever date system is being used it is fairly safe to assume that each day
has a number so subtracting 693594 will convert it into excel. Probably
simplest to have a helper column formatted as a date that subtracts this
number from the imported date number.

Mike
 
Top