Right clicking to summon Format Cells.
 

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?

Right clicking to summon Format Cells.
 

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

"John" wrote in message
...
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?

Right clicking to summon Format Cells.
 

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






"John" wrote in message
...
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?

Right clicking to summon Format Cells.
 

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

On Mar 14, 12:28*am, John wrote:
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?