=DATE(LEFT(A1,1)+2000,1,1)+MOD(A1,1000)

Format as dd/mm/yy

--
Kind regards,

Niek Otten

"Hervinder" wrote in message ...
|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
|