calculate number of months from date entry

C

Cowtoon

What's the best way to enter dates, so that I can have Excel calculate the
number of months between the two dates and what's the best function to use
for calculating the number of months?

Thanks for any suggestions.
 
C

Cowtoon

Hi, thanks for the lead. I found what I needed between it and Excel help.

This is what I ended up with:
=(YEAR(C2)-YEAR(B2))*12+MONTH(C2)-MONTH(B2) and it works to a point.

Do you know if there's a way to calculate a "portion of a month". The above
formula rounds to a full month. Perhaps I should use week instead of month,
then do my own monthly calculation, using say 4.28 weeks per month (using 30
day month).

Any thoughts? Thanks.
 
Top