Forum Discussion
Excel Formula
I need the formula for consecutive days in a row or column minus sundays and holidays
2 Replies
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.
- 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.
