Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting days from cells
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting days from cells
Look in HELP for the WORKDAY() function
If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "B J G" wrote in message ... | 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Subtracting a time from a day and 2 days prior | Excel Discussion (Misc queries) | |||
Subtracting From 2 Cells | Excel Worksheet Functions | |||
Subtracting 2 Now() Cells | Excel Worksheet Functions | |||
subtracting 30 days from any date. | Excel Discussion (Misc queries) |