Date Fill Series

  • Thread starter Thread starter S. Neese
  • Start date Start date
S

S. Neese

We want to find an easy way to populate cells with the
dates of our four-day Monday-Thursday work week for an
entire year. For example, 8/263 8/24, 8/25, 8/26. The
following week dates are 8/30, 8/31, 9/1, 9/2. I have
been trying to use the fill series with no luck. Any help
is greatly appreciated.
 
If this is something you don't have to do a lot of, you could just go ahead
and fill for the entire year.........then sort by Day of the week, and then
delete the Fridays, Saturdays, Sundays.........then resort by date

Vaya con Dios,
Chuck, CABGx3
 
S. Neese, you'll find a lot of good information about date and time
calculations on Chip Pearson's website. Look, specifically, here:
http://www.cpearson.com/excel/DateTimeWS.htm#WeekdaySeries and scroll to the
heading, "Creating a Series of Workdays."

Following his example, I created the formula below. If you enter 8/23/2004
in Cell A2, you can enter this formula in A3:

=IF(WEEKDAY(A2+1)=6,A2+4,IF(WEEKDAY(A2+1)=7,A2+3,IF(WEEKDAY(A2+1)=1,A2+2,A2+
1)))

and copy it down.
 
Back
Top