Quarters

=SUMPRODUCT(--(DATE(YEAR(A1),MONTH(A1)+ROW(A1:A100)*3,DAY(A1))<A 2))

Semi-annual

=SUMPRODUCT(--(DATE(YEAR(A1),MONTH(A1)+ROW(A1:A100)*6,DAY(A1))<A 2))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jer" wrote in message
...
oops!! for that first post
Dear all
Some help please. I have 2 dates a start date and an end date and I have
to
make payments either quarterly or semi annually between the 2 dates, e.g.,
start date = Jan 15 2006 end date = July 15 2015 the number of quarterly
payments that I would have to make between the 2 dates is 37 and the
number
of semi annual payments is 19. Is there a formula that could give me
these
results
--
thanks as always for the help