I need some help building a sheet that will autopopulate all the dates of
week days for a year based on the date entered in the first cell. The cells
are in groups of ten (for a two week pay period) but many rows separate each
group of ten. So I need the dates for week days only to run in:

C3 through L3
C58 through L58
C113 through L113
etc

I can autofill a given row with weekdays easily but I don't know how to get
the next row to pick up where the last one left off. Thanks in advance for
any help.

spence

In C58

=C3+14

etc.?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"spence" wrote in message
...
I need some help building a sheet that will autopopulate all the dates of
week days for a year based on the date entered in the first cell. The
cells
are in groups of ten (for a two week pay period) but many rows separate
each
group of ten. So I need the dates for week days only to run in:

C3 through L3
C58 through L58
C113 through L113
etc

I can autofill a given row with weekdays easily but I don't know how to
get
the next row to pick up where the last one left off. Thanks in advance for
any help.

spence