Calculating the number of months

  • Thread starter Thread starter Philangr8
  • Start date Start date
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
 
hi
assuming that start date is in A1 and end date is in b1....
=DATEDIF(A1,B1,"m")+1

regards
FSt1
 
Back
Top