Calculating month end count

[fmsavey]

I want to be able to calculate how many month end dates there are between any two dates.

Example: Between 1/1/2007 and 3/14/2007 there are 2 month end dates. They are 1/31/2007 and 2/28/2007.

Can someone help me with seemingly easy problem?

Thanks in advance!

[Digital Life]

Try Brian Dunning's web site:

http://www.briandunning.com/cf/680

[comment]

Try:

12 * Year ( EndDate ) + Month ( EndDate ) - 12 * Year ( StartDate ) - Month ( StartDate )

Note that this includes StartDate but excludes EndDate, so that:

Jan 1, 2007 ... Mar 31, 2007 = 2

Jan 31, 2007 ... Feb 1, 2007 = 1