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 move it to the next business day if that calculation falls on a Holiday or weekend.  Is there a way to add to the equation that still subtracts my regular 30 calendar days from my set date but then automatically moves it to the next business day (usually Monday) after a weekend and holiday?

excel
Formulas and Functions

1 Reply

  • 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