Calculate the number of days in months between two dates

Jessejr04

New Member
Joined
Apr 15, 2004
Messages
22
Can someone please provide me with a formula that will calc the months between two dates. For example, for 06/01/2005 - 07/15/2005, the function should return approx. 1.5 as the number of months.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
If you are looking for approximate:

=Round((b1-a1)/30,1)
 

Jessejr04

New Member
Joined
Apr 15, 2004
Messages
22
Calculating months between two dates.

Thanks. Is there a way to get the exact value?
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
It would be pretty complex, I think, as you would have to account for the number of days in each month between the two dates, including the partial days of the months at the range ends.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,650
Members
412,335
Latest member
cinciri99
Top