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.

=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.