The last 2 are optional but that is where the function shines and differs from the Networkdays function. The NETWORKDAYS function calculates the difference between two dates excluding weekend days Saturdays and Sundays. Select two cells which you will input the start date time and end date time and right click to select Format Cells form the context menu.
To add days to a date while excluding specific days ie.
How to do it. Select two cells which you will input the start date time and end date time and right click to select Format Cells form the context menu. RoundDown DateDiff StartDateSelectedDate EndDateSelectedDate Days 7 0 5. In the example shown the formula in C7 is.
