MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I convert day of year to a date?


Posted by Melody on April 26, 2001 12:07 PM

I am running statistics on a machine logged report, which gives the date as the day of the year (ie, 364 is December 24). The fact that it does not have a year is no problem, but how do I convert the 364 to read December 30 or 12/30? Since there are many files containing about 20,000 rows each of different dates, I don't want to do this manually.

Posted by Melody on April 26, 2001 12:14 PM

DUH -- never mind -- how about if I just set the date function to a different scope?

Sheesh -- I've been playing with this all day, and figured it out 3 minutes after I posted a help!

Posted by Joan Manlwy on April 27, 2001 6:13 AM

one simple way is to enter 1/1/yy for the year ]
into a cell. then have a cell = 1/1/yy + days.
this will be the date for that number of days in
year yy.