Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

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.

Re: How do I convert day of year to a date?

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!


Re: How do I convert day of year to a date?

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.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.