How to get workdays between dates in Excel
To calculate the number of workdays between two dates, you can use the NETWORKDAYS function. NETWORKDAYS automatically excludes weekends, and it can optionally exclude a custom list of holidays as well. Formula =NETWORKDAYS(start_date,end_date,holidays) Note that NETWORKDAYS includes both the start and end dates in the calculation if they are workdays. Explanation For example, if you …