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
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.