NextDayOfWeek(Date date, Numeric weekday)

Returns the date of the next specified weekday following the given date.

Parameters

date

The date to start.

weekday

The numeric value representing the weekday (e.g. 0=Sunday, 1=Monday, etc.).

Returns

Date

Examples

• NextDayOfWeek([Date Received], 1) returns the first Monday following the date in the "Date Received" column.
• NextDayOfWeek(#2013-03-22#, 3) returns the first Wednesday date, 03/27/2013.