Forum Discussion

Mpaynter28's avatar
Mpaynter28
Copper Contributor
May 14, 2024

Workday Formula auto filling holiday table to the next cells

I am using the workday formula to get 15 business days after the request to extend a due date. Broker ask for an extension X day, we approve and change their invoice due date to Y Day. I wish to excl...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 14, 2024

Mpaynter28 

=WORKDAY( C1,15,Holiday!$B$1:$B$10)

 

Does this return the intended result?

  • bmaggard's avatar
    bmaggard
    Copper Contributor
    Oct 18, 2024
    Not the OP, but THANK YOU! I'm still relatively new to using more "robust" formulas in Excel and couldn't find the fix for the auto-advance on the cells.

Resources