3. Days()

The number of calendar days between two dates is calculated using this function = DAYS.

SYNTAX =DAYS (end_date, start_date)

 

4. Networkdays

The number of weekends is automatically excluded when using the function. It’s classified as a Date/Time Function in Excel. The net workday’s function is used in finance and accounting for determining employee benefits based on days worked, the number of working days available throughout a project, or the number of business days required to resolve a customer problem, among other things.

SYNTAX = NETWORKDAYS (start_date, end_date, [holidays])