software

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

Quarters

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

Semi-annual

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

gt; Quarters
gt;
gt; =SUMPRODUCT(--(DATE(YEAR(A1),MONTH(A1) ROW(A1:A100)*3,DAY(A1))lt;A 2))
gt;
gt; Semi-annual
gt;
gt; =SUMPRODUCT(--(DATE(YEAR(A1),MONTH(A1) ROW(A1:A100)*6,DAY(A1))lt;A 2))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;jerquot; gt; wrote in message
gt; news
gt; gt; oops!! for that first post
gt; gt; Dear all
gt; gt; Some help please. I have 2 dates a start date and an end date and I have
gt; to
gt; gt; make payments either quarterly or semi annually between the 2 dates, e.g.,
gt; gt; start date = Jan 15 2006 end date = July 15 2015 the number of quarterly
gt; gt; payments that I would have to make between the 2 dates is 37 and the
gt; number
gt; gt; of semi annual payments is 19. Is there a formula that could give me
gt; these
gt; gt; results
gt; gt; --
gt; gt; thanks as always for the help
gt;
gt;
gt;

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

Bob

quot;jerquot; gt; wrote in message
news
gt; Bob
gt; thank you exceedingly much
gt; --
gt; thanks as always for the help
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Quarters
gt; gt;
gt; gt; =SUMPRODUCT(--(DATE(YEAR(A1),MONTH(A1) ROW(A1:A100)*3,DAY(A1))lt;A 2))
gt; gt;
gt; gt; Semi-annual
gt; gt;
gt; gt; =SUMPRODUCT(--(DATE(YEAR(A1),MONTH(A1) ROW(A1:A100)*6,DAY(A1))lt;A 2))
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;jerquot; gt; wrote in message
gt; gt; news
gt; gt; gt; oops!! for that first post
gt; gt; gt; Dear all
gt; gt; gt; Some help please. I have 2 dates a start date and an end date and I
have
gt; gt; to
gt; gt; gt; make payments either quarterly or semi annually between the 2 dates,
e.g.,
gt; gt; gt; start date = Jan 15 2006 end date = July 15 2015 the number of
quarterly
gt; gt; gt; payments that I would have to make between the 2 dates is 37 and the
gt; gt; number
gt; gt; gt; of semi annual payments is 19. Is there a formula that could give me
gt; gt; these
gt; gt; gt; results
gt; gt; gt; --
gt; gt; gt; thanks as always for the help
gt; gt;
gt; gt;
gt; gt;