Dates Subtracting dates.

H

help me

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

John Mansfield

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).
 
R

Ron Rosenfeld

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.
Click to expand...


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

Format as Number with 0 decimal places.


--ron
 
Top