# Calculate the number of days in months between two dates

#### Jessejr04

##### New Member
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.

### 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
If you are looking for approximate:

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

#### Jessejr04

##### New Member
Calculating months between two dates.

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

#### NBVC

##### Well-known Member
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.

#### nbrcrunch

##### Well-known Member

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,549
Messages
5,838,044
Members
430,527
Latest member
MyFace2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back