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