Convert julian date
Ignore my previous post (wherever it went) I had an elderly moment, it's a
julian date i.e. day 59 of 2005, use this
=DATE(IF((LEFT(A1,2)+0)<30,2000,1900)+LEFT(A1,2),1 ,RIGHT(A1,3))
Mike
"JHL" wrote:
I have a julian format of YYDDD. The formula I'm using is off a day and a
century.
Formula =date(left(a1,2),1,(mid(a1,3,3))
05059 = 3/31/1905
How can I get the correct answer of 2/28/2005?
Thanks in advance.
|