Excel: Calculate the number of 1st of the months


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!


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of July 15, 2017.


For more resources for Microsoft Excel