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!
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!