| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Day number of given date in a year
Today = Mar 20, 79th day in the year 2005. need simple function to calculate
that for any given date in any given year. |
|
#2
|
|||
|
|||
|
=TODAY()-DATE(YEAR(TODAY()),1,0)
-- HTH Bob Phillips "Jeff Gordon" <Jeff wrote in message ... Today = Mar 20, 79th day in the year 2005. need simple function to calculate that for any given date in any given year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
| Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
| Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
Hybrid Mode
