Networkdays & Networkdays.intl Excel Formulas

Dear friends, Would like to share one more very useful excel function : (NETWORKDAYS) There are two formulas 1) Networkdays 2) Networkdays.intl. Purpose: Get the number of working days between two dates Syntax: =NETWORKDAYS (start_date, end_date, [holidays]) Parameter list: start_date - The start date. end_date - The end date. holidays - [optional] A list of one or more dates that should be considered non-work days. Note: Working days exclude weekends and dates supplied as holidays. NETWORKDAYS can be used to calculate employee benefits that accrue based on days worked, the number of working days available in a certain time range.