date intervals
 

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

date intervals
 

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

date intervals
 

Bob
thank you exceedingly much
--
thanks as always for the help


"Bob Phillips" wrote:

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

date intervals
 

Forgot to mention that the start and end dates were in A1 and A2
respectively, but I guess that you figured that <vbg

Bob

"jer" wrote in message
...
Bob
thank you exceedingly much
--
thanks as always for the help


"Bob Phillips" wrote:

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