Excel - Day of year to date format

  • Thread starter Thread starter Bren.ie
  • Start date Start date
B

Bren.ie

Is it possible to convert day of year to date format (assuming all date
are 2004)
e.g. 001 to 01 January 2002
or 366 to 31 December 200
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Convert text date to mmddyyy date 2
Conditional Formatting Quartely Months 2
date and time calculations in Excel 2003 3
How to convert decimal year to date format in excel 2
Dates and days of the week 3
Calculating Dates Within Fiscal Year 2
Date format 5

Back
Top