Subtracting days from cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

probably a simple question, but I'm just not figuring this one out....

Column B which is in Spreadsheet B is labeled "Must Ship by Date". We need
it to contain a date which is the shipping date 8 days before the Event Date
in column A from Spreadsheet A.
However, if that Must ship by Date falls on a weekend or holiday (standard)
it needs to ship the previous Friday or previous working day.

I hope that makes sense.

Thanks so much for your help.
 
Look in HELP for the WORKDAY() function

If you get a #NAME error:

Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| probably a simple question, but I'm just not figuring this one out....
|
| Column B which is in Spreadsheet B is labeled "Must Ship by Date". We need
| it to contain a date which is the shipping date 8 days before the Event Date
| in column A from Spreadsheet A.
| However, if that Must ship by Date falls on a weekend or holiday (standard)
| it needs to ship the previous Friday or previous working day.
|
| I hope that makes sense.
|
| Thanks so much for your help.
 
Back
Top