Help with Date Format

H

Hervinder

I need help with data that i have exported from a database.

The date column is in a format i havent seen before

6093 Basically the "6" is for 2006, "093" is 93 days since the first of Jan.

Can someone please help me use the date function to get this into dd/mm/yy
format.

Thanks in advance
Hervinder
 
D

David Biddulph

Hervinder said:
I need help with data that i have exported from a database.

The date column is in a format i havent seen before

6093 Basically the "6" is for 2006, "093" is 93 days since the first of
Jan.

Can someone please help me use the date function to get this into dd/mm/yy
format.
Click to expand...

What about
=DATE(2000+INT(A1/1000),1,MOD(A1,1000))
or =DATE(2000+LEFT(A1,1),1,MID(A1,2,3)) ?
 
R

Ron Coderre

Try this:

For a value in A1
B1: =DATEVALUE("1/1/"&INT(A1/1000))+MOD(A1,1000)-1

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
Top