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

Replies
4
Views
120
Replies
1
Views
247
Replies
7
Views
93
Replies
2
Views
72
Replies
15
Views
228