I have this formula that calculates a date 4 days prior to the entered date in cell H7:
=IF($H$7="","",IFERROR(WORKDAY.INTL($H$7,-4,11,$C$18:$C$37),""))
It sometimes results in a weekend and I want the formula to give me the Friday before if the result falls on a weekend.
I also have another formula that calculates 4 days after the date entered into H11:
=IF($H$11="","",IFERROR(WORKDAY.INTL($H$11,4,11,$C$18:$C$37),""))
It sometimes results in a weekend and I want the formula to give me the Monday after if the result falls on a weekend.
=IF($H$7="","",IFERROR(WORKDAY.INTL($H$7,-4,11,$C$18:$C$37),""))
It sometimes results in a weekend and I want the formula to give me the Friday before if the result falls on a weekend.
I also have another formula that calculates 4 days after the date entered into H11:
=IF($H$11="","",IFERROR(WORKDAY.INTL($H$11,4,11,$C$18:$C$37),""))
It sometimes results in a weekend and I want the formula to give me the Monday after if the result falls on a weekend.