what does it mean

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In three instances I have used this formula successfully to calculate an age in years: =SUM(J19-C1)/365. J19 & c1 are formatted as dates and the answer cell is formatted as a number. When I try to use the same set up in subsequent cells the answer returned is "#value". If I change the date in one of the problem cells to be the same as in one of the cells that calculates correctly, #value changes to the correct answer. Has anyone got a solution for this?
 
Not really sure what's happening, but ...

Your formula can be reduced to

: =(J19-C1)/365

("SUM" is not required)

and when you say:

"When I try to use the same set up in subsequent cells"

do you mean you copy the formula down or across from
where it is ?

Is one of the cells, either J19 or C1,
supposed to be fixed, i.e. $J$19 or $C$1 ?

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------
Wayne said:
In three instances I have used this formula successfully to calculate an
Click to expand...
age in years: =SUM(J19-C1)/365. J19 & c1 are formatted as dates and the
answer cell is formatted as a number. When I try to use the same set up in
subsequent cells the answer returned is "#value". If I change the date in
one of the problem cells to be the same as in one of the cells that
calculates correctly, #value changes to the correct answer. Has anyone got a
solution for this?
 
Back
Top