Thank you so much...that worked, and I was able to implement it to the
timesheet. One little problem...any cells that are now blank (as they
should be), the cells above with the corresponding days of the week
are now showing #VALUE!. How can I resolve this?

I can't tell you how much I appreciate your help on this...as I'm sure
you can tell, I am no programmer, and this has been making me nuts for
days!

Rondi

On Jun 21, 11:01*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
In my first post, I don't think I explained what I wanted you to do very
well. Try this experiment on a blank sheet so you can see what I was
attempting to tell you. We will use I10 to hold your first or sixteenth of
the month date (and only those dates). Put the formula =I10+1 in J10 and
copy it across to U10 (so that U10 contains the formula =T10+1), then put
the following formulas in the indicated cells...

V10: * =IF(U10+1DATE(YEAR($I10),MONTH($I10)+1,0),"",U10+ 1)

W10: *=IF(U10+2DATE(YEAR($I10),MONTH($I10)+1,0),"",U10 +2)

X10:
=IF(DAY(I10)=1,"",IF(U10+3DATE(YEAR($I10),MONTH($ I10)+1,0),"",U10+3))

Okay, put various start of pay-period dates in I10 and watch how the cells
(especially at the end) change. Also note how it adjust for leap years in
February. Does that help you any?

Rick

wrote in message

...
In its current setup, the user simply types in the first date of the
pay period (the 1st or the 16th in date format) *in I10, and all the
corresponding cells auto-populate with the calendar dates that follow
as a result of the formulas I've listed.

Hope this helps to clarify.

Thanks!

On Jun 21, 8:40 pm, "Rick Rothstein \(MVP - VB\)"



wrote:
As I said in my first post, I don't fully understand the structure of your
worksheet and, unfortunately, nothing in your last post has changed that.