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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date formula 1
count months 7
calculate number of months based on one date 1
Days in a specific month 2
Calculate # of months if a date is given 4
Dates Workdays 2
calculate number of months 2
Months between two dates 5

Back
Top