Right clicking to summon Format Cells.

[John]

In cells A1 I have Name-in cell B1 Location C1Title E1 Hire Date F1
Salary. I then have inserted A new Collumn D1 which is called
Service. In cell E2 I have a Hire Date of 11/24/98 and in cell F2
Salary is $29,500. In the newly formed Collumn D in D2 I have a
Formula =(Today()-E2)/365. I should be getting the Value 4.9, But I
come up with 9.306849315. When right clicking on the Hire Date
collumn to format cells and choosing the Number Tab and then clicking
Date I need the sample area in the format dialog box to specifically
say "Date" to correctly come to the right value. How could a beginner
trouble shoot this problem in formatimg cells to come to the correct
value?

 

[Tyro]

The very fact that you should be getting 4.9 as an answer and that you are
getting 9.3 says it is not a formatting problem but a calculation problem.
Please include the values in the cells and your formula.

Tyro

 

[Conan Kelly]

John,

Why should you be getting a value of 4.9?

=(Today()-E2)/365
=(#3/16/2008# - #11/24/1998#)/365
=(39520 - 36123)/365
=(3397 days)/(365 days)
=9.306.... Years

How is that supposed to equal 4.9 years?

Conan

 

[Pete_UK]

Just think about it - it's now 2008, so someone who started for you in
1998 will have been working for 9 or 10 years, so why do you think
that 9.3 years is a wrong answer? Why do you think it should be 4.9
years?

Pete