I've been trying to develop a production schedule in Excel. I'd like to put
an end date and have Excel calculate each activities' start date based on the
number of days needed. I can do a simple subtraction formula (end date-#of
days) however that does not take into account weekends and holidays. I tried
the Workday function but that didn't work.

Suggestions are most appreciated. Thank you!