datewrkdy

Date of future or past workday

Syntax

EndDate = datewrkdy(StartDate,NumberWorkDays,NumberHolidays)

Description

EndDate = datewrkdy(StartDate,NumberWorkDays,NumberHolidays) returns the datetime of the date a given number of workdays before or after the start date.

Any input can contain multiple values, but if so, all other inputs must contain the same number of values or a single value that applies to all.

For example, if StartDate is an n-row datetime, then NumberWorkDays must be an N-by-1 vector of integers or a single integer. EndDate is then an N-by-1 vector of datetimes.

If StartDate is a string or date character vector, EndDate is returned as a serial date number. Use the function datetime to convert serial date numbers to formatted datetime arrays.

If StartDate is a datetime array, then EndDate is returned as a datetime array.

Examples

Determine the Date for a Future Workday

Determine the EndDate for a future workday using a date character vector for StartDate.

StartDate = '20-Dec-1994';
NumberWorkDays = 16;
NumberHolidays = 2;
 
EndDate = datewrkdy(StartDate, NumberWorkDays, NumberHolidays)

EndDate = 
728671

datestr(EndDate)

ans = 
'12-Jan-1995'

Determine the EndDate for a future workday using a datetime for StartDate.

EndDate = datewrkdy(datetime(2000,12,12), 16, 2)

EndDate = datetime
   04-Jan-2001

Determine the EndDate for future workdays using a vector for NumberWorkDays.

NumberWorkDays = [16; 20; 44];
EndDate = datewrkdy(datetime(2000,12,12), NumberWorkDays, 2)

EndDate = 3×1 datetime
   04-Jan-2001
   10-Jan-2001
   13-Feb-2001

Input Arguments

StartDate — Start date

datetime array | string array | date character vector

Start date, specified as an N-by-1 or 1-by-N vector using a datetime array, string array, or date character vectors.

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

Data Types: char | string | datetime

NumberWorkDays — Number of work or business days in future (positive) or past (negative)

positive or negative integers

Number of work or business days in future (positive) or past (negative) that includes the starting date, specified as an N-by-1 or 1-by-N vector containing positive or negative integers.

NumberHolidays and NumberWorkDays must have the same sign.

Data Types: double

NumberHolidays — Number of holidays within NumberWorkDays

positive or negative integers

Number of holidays within NumberWorkDays, specified as positive or negative integers using an N-by-1 or 1-by-N containing values for the number of days movement in terms of holidays into the future (if positive) or past (if negative).

NumberHolidays and NumberWorkDays must have the same sign.

Data Types: double

Output Arguments

EndDate — Date of future or past workday

vector

Date of future or past workday, returned as an N-by-1 or 1-by-N vector for the future or past date.

Version History

Introduced before R2006a

R2022b: Serial date numbers not recommended

Although datewrkdy 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.