How To Subtract a # of days from a date and return only weekdays

I am looking to subtract 3 days from a due date and return a date that is a weekday. Example the Ship Due Date is 3/11/15 subtract 3 days to get Production Due date of 3/8/15...Production Due Mondays for Thurs ship dates, Production Due Tuesday for Fri Ship Dates, Wed for Monday, Thurs for Tues, and Fri for Wed. Working the IF statement combination with the basic subtraction formula and getting errors...Help!

Re: How To Subtract a # of days from a date and return only weekdays

Quote from Luke M;740457

Hello ItsmeJL, and welcome to the forum!

As Mar 8, 2015 is a Sunday, I think your original example is wrong, but based on the other examples, formula would be:
=WORKDAY(A2,-3)

WORKDAY has an optional 3rd argument, where you can give a range of cells containing holidays, if you so wish to exclude those too (in addition to weekends).

Thanks all!!!

The above worked with the exception of the holidays. On a separate worksheet, I typed the dates of the holidays, added that array to the WORKDAY wizard in Holidays cell and it still listed 5/25/15 (memorial day). 5/25/15 is the correct 3 days less than the 5/28/15 ship date.