How can I convert Day of the Year to a mm/dd format in Excel?
Date of the Year: e.g. 1= Jan 1, 177 = June 27.
For example, how do I convert "177" to 6/27?
This will work for year 2013 because Jan 01, 2013 is 41,274 days after Jan 01, 1900
For numbers greater than 59 (31+28), the answer is different for leap year and non-leap year. To get the answers for the current year, put
in a helper column and format as you wish. To use some other year, use