| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
show date as day of the year
i would like to show jan 1st is 1, or 8/2 is 214 ect
whats the function?? thanks brad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show date as day of the year
Try this
=A1-DATE(YEAR(A1),1,0) date in A1 and format as general Mike "Brad" wrote: i would like to show jan 1st is 1, or 8/2 is 214 ect whats the function?? thanks brad |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
show date as day of the year
Worked!!!!
thank you "Mike H" wrote: Try this =A1-DATE(YEAR(A1),1,0) date in A1 and format as general Mike "Brad" wrote: i would like to show jan 1st is 1, or 8/2 is 214 ect whats the function?? thanks brad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a year date into a specific day date | Charts and Charting in Excel | |||
| Creating a formula to show year to date total. | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS? | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Linear Mode
