Excel :: Formula Must Be Confirmed With CTRL+SHIFT+ENTER Not Just ENTER
Excluding dates from calendar:
The BEST WAY:
HOW TO: Use NETWORKDAYS with Multiple Holidays in Excel
A second, less obvious but workable solution:
Calendar calculations excluding specific dates - Excel Help Forum
Not particularly simple to do but you could use this formula
=SMALL(IF((WEEKDAY(ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10))))<>1)*(ISNA(MATCH(ROW(INDIRECT(A2+ 1&":"&WORKDAY(A2,B2,G$1:G$10))),G$1:G$10,0))),ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10)))),B2)
confirmed with CTRL+SHIFT+ENTER
where A2 is the start date, B2 the number of days to add and G1:G10 contains holiday dates |
|
