| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Complicated formula
I need to set the following formula but I'm not sure how to proceed:
DATE + 15 days I can do this easily enough, but I also need to have the "15th" day fall on a workday. (so it might actually be "+16" or "+17"). Is there a way to include the WORKDAY formula in the basic date addition? Thanks! -- 6-West |
|
#2
|
|||
|
|||
|
one way:
=A1+15+2*(WEEKDAY(A1)=6)+(WEEKDAY(A1)=7) n article , "sixwest" wrote: I need to set the following formula but I'm not sure how to proceed: DATE + 15 days I can do this easily enough, but I also need to have the "15th" day fall on a workday. (so it might actually be "+16" or "+17"). Is there a way to include the WORKDAY formula in the basic date addition? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dragging a formula | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Replacing MCONCAT with CONCAT_RANGE (in a complicated formula) | Excel Worksheet Functions | |||
| need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
