date function
If 6000 corresponds to Sunday, January 01, 2006
then:
=DATE(2000+LEFT(A1,1),1,RIGHT(A1,3)+1) would display:
Tuesday, April 04, 2006
for 6093
--
Gary's Student
"Hervinder" wrote:
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
|