| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert day of year to numeric value format year+day in 4 digits
I want to convert the day of the year into the format of year then the 3
digit day value - so 9031 would be january 31 2009 - want to have Excel automatically calculate based on current date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort XX/XX (the last 2 digits is the year in ascending orde | Excel Discussion (Misc queries) | |||
| How to convert date to financial year format 2006-07 | Excel Worksheet Functions | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| how do I convert a dates in a year quarters in a year? | Excel Discussion (Misc queries) | |||
| month & year format in two digits | Excel Discussion (Misc queries) | |||
Threaded Mode
