I'm assuming A11 is in your "From" column (so it will contain a date that is
either the 1st or the 16th of the month). If so, and assuming B11 is in your
"To" column, put this formula in B11...

=DATE(YEAR(A11),MONTH(A11)+(DAY(A11)=16),15*(DAY(A 11)=1))

Rick


"craezer" wrote in message
...
Thanks, Rick, that did the trick!

One more question. There are two cells that have the pay period starting
and
ending dates, "From" and "To". Is there a way to have the dates entered
into
those cells as well? The first period seems to be easy enough. If I select
the 1st, the 15th pops into the "To" cell. It's the second period that has
me
stumped. Easy enough to get the 16th in the "From" cell, but I need the
last
day of the month in the "To" cell and I don't know what the formula is to
get
that.

Thanks again!

"Rick Rothstein (MVP - VB)" wrote:

Assuming the only dates that will ever go in A11 are the 1st or the 16th
of
a given month, try putting this formula...

=IF(AND(DAY(N(A11)+1)DAY($A$11),DAY(N(A11))<15), A11+1,"")

in A12 and copy it down to A26.

Rick


"craezer" wrote in message
...
I am trying to display rows by pay period. The dates would be from the
1st
to
the 15th or 16th to the end of the month.

I am using a calendar control to select the start date. The calendar
control
inserts the pay period start date into A11. Then
A12 is =(A11+1)*(MONTH(A11+1)=MONTH($A$11))
A13 is =(A12+1)*(MONTH(A12+1)=MONTH($A$11))
and so on.

If I select the 16th for the start, it correctly shows rows for the
16th
to
the month end except for numerous blank rows after the last date. But
if I
select the first pay period, the entire month displays.

What I am trying to accomplish is to display only the neccessary rows
for
the pay period, whether it starts on the 1st or 16th, without extra
dates
or
blank rows.