In cell A1 add the date 12/31/2004. In cell B1 add the date 01/01/2004. In
cell C1 add the formula "=A1-B1". Change the format in cell C1 to "Number"
(go to the standard toolbar and hit Format - Cells - Number with decimal
places equal to zero).

----
Regards,
John Mansfield
http://www.pdbook.com

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