Hello Les,

You are using 30 days to represent a month but, of course, not all
months have 30 days. This is why you have a discrepancy in the count.
Try using DATEDIF to count the number of months, e.g.

=DATEDIF(TODAY,Q30,"m")+1

that will give 1 when Q30=TODAY and should also give the correct result
when Q30 is 20th Sept 2002.

Clearly you will need to change your other formulas accordingly

Be careful if the payment date is late in the month. If Q30 is 31st
January, for instance, then formula won't count 2 payments until 1st
March


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44467