Entering a Formula / Wrong value
 

I have inserted a new column into the work sheet called column D, I have
named the cell D1 Service. In cell D2 I enter the formula =(TODAY()-E2)/365
and should come up with the Value 4.9 in D2 and them drag the fill handle
down 14 cells to compute the rest of the length in the new column D. But in
cell D2 I keep getting the Value 9.58989, I have tried reducing the # of
decimals and also widening the with of the new column D, but with no luck.
As a new Excel user can someone give me a tip on how to trouble shoot this
situation?

Entering a Formula / Wrong value
 

I get 4.9 if E2 contains 31 December 2002 or 9.58989 if E2 has 24 April
1998. What is held in E2?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"John" wrote in message
...
I have inserted a new column into the work sheet called column D, I have
named the cell D1 Service. In cell D2 I enter the formula
=(TODAY()-E2)/365
and should come up with the Value 4.9 in D2 and them drag the fill handle
down 14 cells to compute the rest of the length in the new column D. But
in
cell D2 I keep getting the Value 9.58989, I have tried reducing the # of
decimals and also widening the with of the new column D, but with no luck.
As a new Excel user can someone give me a tip on how to trouble shoot this
situation?