Forum Discussion

angie_p619's avatar
angie_p619
Copper Contributor
Nov 10, 2022

Roll Calculated Deadline Date from Holiday/Weekend to Next Business Day

I use excel to calculate my legal deadlines and use the very basic formula of =SUM(B7,-30) (B7 is my set date I need to subtract multiple deadlines from) to get my deadline date and then manually mov...
excel
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Steel Contributor
Nov 10, 2022

Hi angie_p619 

 

You can use the WORKDAY() function to easily calculate the next business deadline. This function allows calculating working days by excluding weekends and any dates identified as holidays.

 

A sample file is attached for your reference.

Please let me know if it works for you.

 

Thanks

Tauqeer