busdays

Business days for given period

Syntax

bdates = busdays(sdate,edate)

bdates = busdays(___,bdmode,Holiday)

Description

bdates = busdays(sdate,edate) generates a vector of business days between the last business date of the period that contains the start date (sdate), and the last business date of period that contains the end date (edate).

bdates = busdays(___,bdmode,Holiday) generates a vector of business days between the last business date of the period that contains the start date (sdate), and the last business date of period that contains the end date (edate) using optional input arguments. If Holiday is not supplied, the dates are generated based on United States holidays. If you do not supply bdmode, bdates generates a daily vector.

Examples

Determine Business Days for a Given Period

Determine the business days for a weekly period.

 bdates = datestr(busdays('1/2/01','1/9/01','weekly'))

bdates = 2x11 char array
    '05-Jan-2001'
    '12-Jan-2001'

The end of the week is considered to be a Friday. Between 1/2/01 (Monday) and 1/9/01 (Tuesday), there is only one end-of-week day, 1/5/01 (Friday). Because 1/9/01 is part of the following week, the following Friday (1/12/01) is also reported.

Determine the business days for a weekly period using a datetime input for sdate.

bdates = busdays(datetime('2-Jan-2001','Locale','en_US'),'9-Jan-2001','weekly')

bdates = 2x1 datetime
   05-Jan-2001
   12-Jan-2001

Determine the business days for a monthly period.

vec = datestr(busdays('1/8/16','3/1/16','monthly'))

vec = 3x11 char array
    '29-Jan-2016'
    '29-Feb-2016'
    '31-Mar-2016'

The start date (1/8/16) is in the month of January, 2016. The last business day for the month of January is 1/29/16 (Friday). The end date (3/1/16) is in the month of March, 2016. The last business day for the month of March is 3/31/16 (Thursday). The month of February, 2016 lies between the start date and the end date. The last business day for the month of February is 2/29/16 (Monday).

Input Arguments

sdate — Start date

datetime scalar | string scalar | date character vector

Start date, specified as a scalar datetime, string, or date character vector.

To support existing code, busdays also accepts serial date numbers as inputs, but they are not recommended.

Data Types: char | string | datetime

edate — End date

datetime scalar | string scalar | date character vector

End date, specified as a scalar datetime, string, or date character vector.

To support existing code, busdays also accepts serial date numbers as inputs, but they are not recommended.

Data Types: char | string | datetime

bdmode — Frequency of business days

DAILY (1) (default) | nonnegative numeric with values 1 through 5 | date character vector with values DAILY, WEEKLY, MONTHLY, QUARTERLY, SEMIANNUAL or ANNUAL

Frequency of business days, specified as a nonnegative numeric with values 1 through 5 or date character vector with values of DAILY, WEEKLY, MONTHLY, QUARTERLY, SEMIANNUAL, or ANNUAL

Valid periodicities include:

• DAILY, Daily, daily, D, d, 1 (default)

• WEEKLY, Weekly, weekly, W, w, 2

• MONTHLY, Monthly, monthly, M, m, 3

• QUARTERLY, Quarterly, quarterly, Q, q, 4

• SEMIANNUAL, Semiannual, semiannual, S, s, 5

• ANNUAL, Annual, annual, A, a, 6

  Character vectors must be enclosed in single quotation marks.

For example, if bdmode is set to monthly, busdays returns end-of-month business dates for all full or partial months between the start date and end date inclusive.

Data Types: double | char

Holiday — Holiday and nontrading-day dates

if Holiday is [ ] holiday dates are based on United States holidays specified by holidays (default) | datetime array | string array | date character vector

Holiday and nontrading-day dates, specified as a vector using a datetime array, string array, or date character vectors. If you specify Holiday, you must also supply the frequency bdmode. Using a Holiday value of NaN uses a holiday list that has no dates.

To support existing code, busdays also accepts serial date numbers as inputs, but they are not recommended.

Data Types: char | string | datetime

Output Arguments

bdates — Business days

column vector

Business days, returned as a column vector of business dates, in datetime format (if sdate, edate, or Holiday are in datetime format). Business dates can exist before and/or after the specified sdate and edate.

Version History

Introduced before R2006a

R2022b: Serial date numbers not recommended

Although busdays supports serial date numbers, datetime values are recommended instead. The datetime data type provides flexible date and time formats, storage out to nanosecond precision, and properties to account for time zones and daylight saving time.

To convert serial date numbers or text to datetime values, use the datetime function. For example:

t = datetime(738427.656845093,"ConvertFrom","datenum");
y = year(t)

y =

        2021

There are no plans to remove support for serial date number inputs.