Convert julian date
=DATE(20&LEFT(B29,2),1,RIGHT(B29,3))
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"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.
|