Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem when clicking on cells for a formula | Excel Discussion (Misc queries) | |||
Clicking on linked cells | Excel Worksheet Functions | |||
Problem with clicking on cells | Excel Discussion (Misc queries) | |||
Clicking cells on sheet creates Text Box. How do I turn this off? | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) |