Forum Discussion
Mike_Sullivan
Oct 08, 2023Copper Contributor
Excel Formula
I need the formula for consecutive days in a row or column minus sundays and holidays
SergeiBaklan
Oct 09, 2023MVP
You may use WORKDAY.INTL function - Microsoft Support. For example, enter in A1 first workday, in A2
=WORKDAY.INTL(A1,1,1, holidays)
and drag it down. holidays here is named range with holiday dates in your location, third parameter (1) assumes Sat and Sun are weekends. You may change it other one.