I am creating a type of planning/production schedule. I need to have a "moving" autofill of dates that removes weekends, but I also need to do this ever 4 lines. We can build 4 units a day.
Ex.
=Today() (9/20) 9/20, 9/20, 9/20, 9/23, 9/23, 9/23, 9/23, 9/24, 9/24,ect.

I can only get the weekdays to work if its only one line at a time. If I go every 4 lines, I cannot remove the weekends. Currently using Excel 2003

Thanks everyone.