dates for weekdays in non-contiguous cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top