Convert julian date
What date do you think the 59th day of the year is, Mike?
--
David Biddulph
"Mike H" wrote in message
...
Hi,
Why is 2/28/2005 the correct date for 05059?
I can understand the first 05 being the year but how do we arrive at 28
Feb
from the 059 bit?
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.
|