Hi
use DATEDIF. See:
http://www.cpearson.com/excel/datedif.htm
--
Regards
Frank Kabel
Frankfurt, Germany
"Cowtoon" schrieb im Newsbeitrag
...
Hi,
I used the following formula to calculate the number of months passed
between two dates. Unfortunately, I need a little more accuracy than
what
this provides. This formula results in full month calculations only.
Is
there a way to get a more accurate calculation. I wouldn't even mind
calculating the number of weeks and dividing by 4.28 to arrive at
number of
months, but I don't know the "name" for how to count weeks. The
formula
won't accept "WEEK" as a name like it does for "MONTH".
=(YEAR(C2)-YEAR(B2))*12+MONTH(C2)-MONTH(B2) and it works to a point.
Thanks for any help. Diana
PS ... I posted this request in a reply to one of my own earlier
postings
(which had a different original question) to "general" newsgroup, but
I was
afraid it might get missed because it's not the original question.
My
apologies if this is inappropriate posting behaviour.