Calculate No. on Months between 2 dates

  • Thread starter Thread starter RoyB
  • Start date Start date
R

RoyB

Hi

I need to be able to calculate total no of months between
a date range. The first date range will always start at
the beginning of a month, and the second will always end
at the end of a month, ie;

Start Date = 01/01/03
End Date = 01/06/09

I need to know how many months there are between the
start, and the end date...any ideas guys...?

Thanks
 
The first date range will always start at
the beginning of a month, and the second will always end
at the end of a month, ie;
Click to expand...

You mean except in your example.

Start is in A1
End is in B1

=Datedif(a1,b1,"m")
 
Hi Roy,

Try this formula:

=DATEDIF(StartDate, EndDate, Unit)
** Unit will be "M" for months **

A B C
1 01/01/03 01/06/09 =DATEDIF(A1,B1,"M")

Hope this helps.

Regards,
James S
 
You said it will start on the first of a month and end on
the last day of month, but your example shows otherwise.
either way this formula should work with

A1 = start date B1 = end date format the cell as a
number. without decimals and it will be right every time.


=(B1-A1)/365.25*12
 
Back
Top