Hi Daniel, thanks for the response. I look through the thread and tried a
few of the examples (changing the cells, as appropriate, of course), but it's
not giving the correct results, so I'm not sure what I'm doing wrong. I'm
happy to have a month results of 4.3 or 4.5. I don't need exact number of
days, just the time that has lapsed. I'd even take weeks, then I could
convert to months or portion.

There's gotta be a way to do this.
Thanks again. Diana

"Daniel.M" wrote:

HI,

http://groups.google.com/groups?hl=f...rum-nospam.com

Click on the "Complete Thread" link on that page.

HTH

Daniel M.

"Cowtoon" wrote in message
...
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.