Date Conversion yyyy-365

M

mhickey

I have a speadsheet where the author entered dates with the combination
of the year plus the value of the calendar day value. I.E. December 31,
2005 is reflected as 2005365. Does anyone have a suggestion how to
convert this to a basic date format like mmddyyyy?
 
F

Franz Verga

Nel post *[email protected]* ha scritto:
I have a speadsheet where the author entered dates with the
combination of the year plus the value of the calendar day value.
I.E. December 31, 2005 is reflected as 2005365. Does anyone have a
suggestion how to convert this to a basic date format like mmddyyyy?
Click to expand...

This format of dating is called Julian date. You can check also on line help
for that.

If you have a Julian date in C19, using the formula:

=DATE(LEFT(C19,4),1,0)+RIGHT(C19,3)

you will have a date in your standard format.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top