Calculate the number of 1st of the months

[ClimbGuy]

I have two dates and need to calculate the number of 1st of the months between them.

In order words if i have

January 31, 2017 to March 2, 2017 it should output 2
February 2, 2017 to February 28, 2017 should output 0
January 1, 2017 to February 1, 2017 should also output 1, (I know this could look like two, which is why I wanted to point it out)

Does anyone have any formula recommendations?

Thanks!

 

[Tetra201]

... I assume A1=date 1 and B1= date 2?

Yes. You can change those cells to whatever you need/want. You don't have to change range A:A -- it's just a counter.

 

[ClimbGuy]

Thanks @Tetra201

That did exactly what I was looking for!