Forum Discussion

alvinchang's avatar
alvinchang
Copper Contributor
Apr 02, 2019

returning a working date

I have a future date with 10 free days given and I need a plan date based on future date -(minus) 10 free days but the returning plan date must in working day.

 

Formulas and Functions

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 02, 2019
    In the counting of days, the first day is excluded while the last day is included, such that in your example, 28-Apr-2019 minus 10 days = 18-Apr-2019, which is the tentative plan date. So, if the future date is in A1, the formula for the plan date in B1 is:
    =WORKDAY(A1-10,
    --OR(WEEKDAY(A1-10)={1,7},COUNTIF(Holidays,A1-10)>0),
    Holidays)
    Note that Holidays refer to the defined name of the range containing the holidays.

Resources