CODEWITHSUNDEEP
vbaexcel
Santhosh Rao
Santhosh Rao

Reputation: 7

Find the number of business day between 2 date in an excel sheet

Some background: Have a list of incidents which were open on a certain day and closed on a certain date, this data is kept in an excel sheet.

My issue: I need to find the no of working days (ie count of days excluding sat and sun) in between the date given in the excel sheet.

My question: Is there an inbuild function in excel which checks the calender and gives this needed output.

Upvotes: 0

Views: 1132

Answers (1)

filhit
filhit

Reputation: 2154

NETWORKDAYS function

Description

Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

TIP: To calculate whole workdays between two dates by using parameters to indicate which and how many days are weekend days, use the NETWORKDAYS.INTL function.

Syntax

NETWORKDAYS(start_date, end_date, [holidays])

The NETWORKDAYS function syntax has the following arguments:

  • Start_date Required. A date that represents the start date.

  • End_date Required. A date that represents the end date.

  • Holidays Optional. An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates.

Source

Upvotes: 3

Related Questions