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

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

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

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

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

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