lweekdate

Date of last occurrence of weekday in month

Syntax

LastDate = lweekdate(Weekday,Year,Month)

LastDate = lweekdate(___,NextDay,outputType)

Description

LastDate = lweekdate(Weekday,Year,Month) returns the date number for the last occurrence of Weekday in the given year and month.

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 Year is a 1-by-n vector of integers, then Month must be a 1-by-n vector of integers or a single integer. LastDate is then a 1-by-n vector of date numbers.

LastDate = lweekdate(___,NextDay,outputType) returns the date of last occurrence of weekday in month using the optional arguments for NextDay and outputType.

The type of the output for LastDate depends on the input outputType. If this variable is 'datenum', LastDate is a serial date number. If outputType is 'datetime', then LastDate is a datetime array. By default, outputType is set to 'datenum'.

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

Examples

Determine the Date of Last Occurrence of Weekday in a Month

Determine the last Monday in June 2001.

LastDate = lweekdate(2, 2001, 6); datestr(LastDate)

ans = 
'25-Jun-2001'

Determine the last Monday in a week that also contains a Friday in June 2001 returned as a datetime array.

LastDate = lweekdate(2, 2001, 6,[],'datetime')

LastDate = datetime
   25-Jun-2001

Determine the last Monday in a week that also contains a Friday in June 2001:

LastDate = lweekdate(2, 2001, 6, 6); datestr(LastDate)

ans = 
'25-Jun-2001'

Determine the last Monday in May for 2001, 2002, and 2003:

Year = [2001:2003];
LastDate = lweekdate(2, Year, 5);
datestr(LastDate)

ans = 3x11 char array
    '28-May-2001'
    '27-May-2002'
    '26-May-2003'

Input Arguments

Weekday — Weekday whose date you seek

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

Weekday whose date you seek, specified as an integer or a vector of integers from 1 through 7.

• 1 — Sunday

• 2 — Monday

• 3 — Tuesday

• 4 — Wednesday

• 5 — Thursday

• 6 — Friday

• 7 — Saturday

Data Types: single | double

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

NextDay — Weekday that must occur after Weekday in same week

0 = ignore (default) | integer with value 0 through 7 | vector of integers with values 0 through 7

Weekday that must occur after Weekday in same week, specified as an integer or a vector of integers from 0 through 7, where 0 = ignore (default) and 1 through 7 are the same as for Weekday.

Data Types: single | 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 LastDate is in serial date format if 'datenum' is specified, or datetime format if 'datetime' is specified. By default the output LastDate is in serial date format.

Data Types: char

Output Arguments

LastDate — Date for last occurrence of Weekday in given year and month

serial date number | date character vector

Date for last occurrence of Weekday in given year and month, returned as a serial date number or date character vector.

The type of the output for LastDate depends on the optional input argument outputType. If this variable is 'datenum', LastDate is a serial date number. If outputType is 'datetime', then LastDate is a datetime array. By default, outputType is set to 'datenum'.