On Sat, 4 Feb 2006 20:15:48 -0600, daddylonglegs
wrote:


If your start date (15th April 2005) is in A2 and the first day of the
month you wish to check is in B2

=2+(DAY($A$2+28+CEILING(B2-$A$2,14))20)

e.g. in B2 September 1 2005 (format as "mmm-yyyy" if desired)
the above formula will give 3

Much simpler than mine


--ron