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?

Tyro
Thu Mar 13 19:56:16 CDT 2008

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" <Family103082@verizon.net> wrote in message
news:79c1b1ff-ae62-46f2-868c-e3369f7fefbe@m36g2000hse.googlegroups.com...
> 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?

Conan
Thu Mar 13 20:13:25 CDT 2008

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" <Family103082@verizon.net> wrote in message
news:79c1b1ff-ae62-46f2-868c-e3369f7fefbe@m36g2000hse.googlegroups.com...
> 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?

Pete_UK
Thu Mar 13 20:15:37 CDT 2008

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=A0am, John <Family103...@verizon.net> wrote:
> In cells A1 I have Name-in cell B1 Location C1Title E1 Hire Date F1
> Salary. =A0I then have inserted A new Collumn D1 which is called
> Service. =A0In cell E2 I have a Hire Date of 11/24/98 and in cell F2
> Salary is $29,500. =A0In the newly formed Collumn D in D2 I have a
> Formula =3D(Today()-E2)/365. =A0I should be getting the Value 4.9, But I
> come up with 9.306849315. =A0When 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. =A0How could a beginner
> trouble shoot this problem in formatimg cells to come to the correct
> value?