Calculating the number of months

P

Philangr8

I have a column for start date and end date. I would like a formular that
tells me how many months it is including the start month and end month.

ex. Start date: 11/1/2009 end date: 4/1/2010 this would be 6 months if you
include November and April.

Thanks in advance
 
F

FSt1

hi
assuming that start date is in A1 and end date is in b1....
=DATEDIF(A1,B1,"m")+1

regards
FSt1
 

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

Excel Help with dates 2
Dynamic referencing to files 4
Calculate # of months if a date is given 4
Date issues 1
FORMULA NEEDED FOR MONTHS 1
Calculation of monthly payments per employee 2
Count the Number of Weekdays by Month 3
Convert Number of Month to Number of days 4

Top