| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to number conversion
I need a formula that tells me the day of the year for a date. For example:
06/23/2008 = 175 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date to number conversion
With the date in cell A1: =A1-DATE(YEAR(A1),1,0)
"Byron720" wrote: I need a formula that tells me the day of the year for a date. For example: 06/23/2008 = 175 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date to number conversion
The following function will produce the Julian date you requested.
Substitute the cell address A1 with the cell that contains the date: =A1-DATE(2008,1,0) You will probably have to format the cell for a number format of 0 decimals as it will pick up the data format from the date cell. -- Kevin Backmann "Byron720" wrote: I need a formula that tells me the day of the year for a date. For example: 06/23/2008 = 175 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stop number to date conversion | Setting up and Configuration of Excel | |||
| Number Conversion | Excel Worksheet Functions | |||
| Number Conversion | Excel Discussion (Misc queries) | |||
| Number conversion | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Hybrid Mode
