On Wed, 10 Nov 2004 09:29:13 -0800, "Cowtoon"
wrote:

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.

Diana,

One problem with "exact" is that months vary in length.

Two suggestions:

1. To compute the number of weeks between your two dates:

=(C2-B2)/7

2. To compute months and days:

Months -- =DATEDIF(B2,C2,"m")
Remaining Days -- =DATEDIF(B2,C2,"md")


--ron