THANK YOU THIS IS EXACTLY WHAT I WAS LOOKING FOR.

"Ron Rosenfeld" wrote:

On Thu, 16 Dec 2004 16:11:01 -0800, "help me"
wrote:

first of all I would like to have one row with any date in it (formated for a
regular date) example 12/15/04, in the next cell I would like to have
computed the number of the day in the year example 01/10/03 is the 10th day
of the year so that cell would have a 10 in it.

another example is to day 12/15/04 which is day 350.


=A1-DATE(YEAR(A1),1,0)

Format as Number with 0 decimal places.


--ron