Excel Formula

Copper Contributor

I need the formula for consecutive days in a row or column minus sundays and holidays

2 Replies
Can you pls confirm which holidays you want to consider because holiday dates can vary significantly from one country or region to another. There isn't an international standard for holidays that Excel can automatically recognize.


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.