Entering a Formula / Wrong value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 24 Nov 2007 16:08 GMT

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?

Reply to this Message

Sandy Mann - 24 Nov 2007 17:04 GMT

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

Signature

HTH

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

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

>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
[quoted text clipped - 6 lines]
> As a new Excel user can someone give me a tip on how to trouble shoot this
> situation?

Reply to this Message