calculate number of months from date entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top