# 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

use this asuming A1 has your date

=IF(WEEKDAY(A1-4,1)=1,(A1-4)+1,IF(WEEKDAY(A1-4,1)=7,A1-5,A1-4))

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

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).

Best Regards,
Luke M
=======
"A little knowledge is a dangerous thing."

• 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.

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

Strange, that's not what it should be doing, nor what I see. Can you take a look at the attached, make sure it matches the (general) layout of your formula?

## Files

Best Regards,
Luke M
=======
"A little knowledge is a dangerous thing."

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!