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
 
D

David Biddulph

Wouldn't that return 1 month if the dates were 20 May and 10 Jun? Doesn't
the OP want to include both months?

Mightn't he want
=DATEDIF(DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(B1),MONTH(B1),1),"m")+1 ?
 

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

number of months and days between two dates without approximation 3
Help showing active months between two dates 5
Dynamic referencing to files 4
fiscal year calculation 3
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Calculate # of months if a date is given 4
calculate 6 months forward from a date 8
Date issues 1

Top