Question: how to calculate days between two dates in excel excluding holidays?
Answer: The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates. NETWORKDAYS includes both the start date and end date when calculating work days.