If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Decimals on a date calculation
I'm calculating dates using the formula b6-c6/365.25 and get an answer like
3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? I can't get my head around it! Thanks for any help diane |
#2
|
|||
|
|||
Decimals on a date calculation
What do B6 and C6 actually contain? Are you trying to find out how many
years there are between two dates? If so, then you will need to do this: = (B6-C6)/365.25 Hope this helps. Pete "DianeG" wrote in message ... I'm calculating dates using the formula b6-c6/365.25 and get an answer like 3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? I can't get my head around it! Thanks for any help diane |
#3
|
|||
|
|||
Decimals on a date calculation
Remember that if c6 contains a date c6/365.25 will give the number of years
from 1 January 1900. Any fractional part is a fraction of a year. -- Gary''s Student - gsnu200805 "DianeG" wrote: I'm calculating dates using the formula b6-c6/365.25 and get an answer like 3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? I can't get my head around it! Thanks for any help diane |
#4
|
|||
|
|||
Decimals on a date calculation
Sorry I didn't explain myself fully, I did have two dates in the cells and
the calculation was written (b6-c6)/365.25 to calculate the number of years between the dates. So if this is the case, the decimal is a fraction of the year? .25 would be 3 months? "Gary''s Student" wrote: Remember that if c6 contains a date c6/365.25 will give the number of years from 1 January 1900. Any fractional part is a fraction of a year. -- Gary''s Student - gsnu200805 "DianeG" wrote: I'm calculating dates using the formula b6-c6/365.25 and get an answer like 3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? I can't get my head around it! Thanks for any help diane |
#5
|
|||
|
|||
Decimals on a date calculation
No it is 0.25 days if you mean the decimal part of 365.25
You can use this instead =DATEDIF(B6,C6,"y") for years and =DATEDIF(B6,C6,"ym") for months after the years have been stripped off =DATEDIF(B6,C6,"md") for days after the years and months have been stripped off -- Regards, Peo Sjoblom "DianeG" wrote in message ... Sorry I didn't explain myself fully, I did have two dates in the cells and the calculation was written (b6-c6)/365.25 to calculate the number of years between the dates. So if this is the case, the decimal is a fraction of the year? .25 would be 3 months? "Gary''s Student" wrote: Remember that if c6 contains a date c6/365.25 will give the number of years from 1 January 1900. Any fractional part is a fraction of a year. -- Gary''s Student - gsnu200805 "DianeG" wrote: I'm calculating dates using the formula b6-c6/365.25 and get an answer like 3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? I can't get my head around it! Thanks for any help diane |
#6
|
|||
|
|||
Decimals on a date calculation
Thanks everybody!
"DianeG" wrote: Sorry I didn't explain myself fully, I did have two dates in the cells and the calculation was written (b6-c6)/365.25 to calculate the number of years between the dates. So if this is the case, the decimal is a fraction of the year? .25 would be 3 months? "Gary''s Student" wrote: Remember that if c6 contains a date c6/365.25 will give the number of years from 1 January 1900. Any fractional part is a fraction of a year. -- Gary''s Student - gsnu200805 "DianeG" wrote: I'm calculating dates using the formula b6-c6/365.25 and get an answer like 3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? I can't get my head around it! Thanks for any help diane |
Thread Tools | |
Display Modes | |
|
|