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.