lbusdate

Last business date of month

Syntax

Date = lbusdate(Year,Month)

Date = lbusdate(___,Holiday,Weekend,outputType)

Description

Date = lbusdate(Year,Month) returns the serial date number for the last business date of the given year and month.

Year and Month can contain multiple values. If one contains multiple values, the other must contain the same number of values or a single value that applies to all. For example, if Year is a 1-by-N vector of integers, then Month must be a 1-by-N vector of integers or a single integer. Date is then a 1-by-N vector of date numbers.

Use the function datestr to convert serial date numbers to formatted date character vectors.

Date = lbusdate(___,Holiday,Weekend,outputType) returns the serial date number for the last business date of the given year and month using optional input arguments. The optional argument Holiday specifies nontrading days.

If neither Holiday nor outputType are specified, Date is returned as a serial date number. If Holiday is specified, but not outputType, then the type of the holiday variable controls the type of date. If Holiday is a serial date number or date character vector, then Date is returned as a serial date number.

Examples

Determine the Last Business Date of a Given Year and Month

Determine the Date using an input argument for Year and Month.

Date = lbusdate(2001, 5)

Date = 731002

datestr(Date)

ans = 
'31-May-2001'

Determine the Date using the optional input argument for outputType.

Date = lbusdate(2001, 11,[],[],'datetime')

Date = datetime
   30-Nov-2001

Indicate that Saturday is a business day by appropriately setting the Weekend argument. May 31, 2003, is a Saturday. Use lbusdate to check that this Saturday is actually the last business day of the month.

Weekend = [1 0 0 0 0 0 0];
Date = datestr(lbusdate(2003, 5, [], Weekend))

Date = 
'31-May-2003'

Input Arguments

Year — Year to determine occurrence of weekday

4-digit integer | vector of 4-digit integers

Year to determine occurrence of weekday, specified as a 4-digit integer or vector of 4-digit integers.

Data Types: single | double

Month — Month to determine occurrence of weekday

integer with value 1 through 12 | vector of integers with values 1 through 12

Month to determine occurrence of weekday, specified as an integer or vector of integers with values 1 through 12.

Data Types: single | double

Holiday — Holidays and nontrading-day dates

non-trading day vector is determined by the routine holidays (default) | serial date number | date character vector | datetime array

Holidays and nontrading-day dates, specified as vector.

All dates in Holiday must be the same format: either serial date numbers, or date character vectors, or datetime arrays. (Using serial date numbers improves performance.) The holidays function supplies the default vector.

If Holiday is a datetime array, then Date is returned as a datetime array. If outputType is specified, then its value determines the output type of Date. This overrides any influence of Holiday.

Data Types: double | char | datetime

Weekend — Weekend days

[1 0 0 0 0 0 1] (Saturday and Sunday form the weekend) (default) | vector of length 7, containing 0 and 1, where 1 indicates weekend days

Weekend days, specified as a vector of length 7, containing 0 and 1, where 1 indicates weekend days and the first element of this vector corresponds to Sunday.

Data Types: double

outputType — Year to determine days

'datenum' (default) | character vector with values 'datenum' or 'datetime'

A character vector specified as either 'datenum' or 'datetime'. The output Date is in serial date format if 'datenum' is specified, or datetime format if 'datetime' is specified. By default the output Date is in serial date format, or match the format of Holiday, if specified.

Data Types: char

Output Arguments

Date — Date for the last business date of given year and month

serial date number | date character vector | datetime array

Date for the last business date of a given year and month, returned as a serial date number, date character vector, or datetime array.

If neither Holiday nor outputType are specified, Date is returned as a serial date number. If Holiday is specified, but not outputType, then the type of the holiday variable controls the type of date:

• If Holiday is a serial date number or date character vector, then Date is returned as a serial date number

• If Holiday is a datetime array, then Date is returned as a datetime array.

.