yogi_Starting With Date In Cell H1 (or Today by default) Create Subsequent Weekdays In Cells I1 to 1 Skipping Weekends (Saturday and Sunday)

                                  Google Spreadsheet   Post  #1696
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-11-2014
post by Crosby87: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/nRT7FnzWmTI)
Rolling Dates On Sheets That Excludes Weekends

Hey everyone,

I have set a function of =NOW() in one cell then =H1+1, H1+2, H1+3 etc... and that provides me my dates and they automatically update.

HOWEVER - is there a way to accomplish this where it can exclude weekend dates and only include weekday dates?

Thank you!

Brad

---

Here is what I'm trying to accomplish, here is my sheet - https://docs.google.com/spreadsheets/d/1BG5SyOaWHyH2rToKU9qune3jpPtPiZVdnE8iqjOZuQg/edit?usp=sharing 

So it's a production schedule, and every night column H will delete itself and the next set of columns will roll into its place. Is there any possible way to make it so that column H deletes itself but does not delete Row #1? Or some way to keep H1 cell from deleting?

Thanks!! Really appreciate your help thus far.

---------------------------------------------------------------------------------------------------------------------------------------