Days Until Day of Week Occurrence [DaysUntilDayOfWeek]

Return to Complete List of Functions

The Days Until Day of Week Occurrence function determines the number of days until the next occurrence of a day of the week. Parameters ------------------ Day of Week The day of the week to resolve where:                       1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday. Occurrence    The occurrence number of the day of the week to resolve, where:                       1=First Occurrence, 2=Second, 3=Third, 4=Fourth, 5=Last Occurrence (Fourth or Fifth) Function Value ------------------------ This function determines the number of days until the next occurrence of a day of the week.. The value is zero if the current day is the next occurrence. Examples ------------------ DaysSinceDayOfWeek(2,3) returns the number of days until the next third Monday of a month. DaysSinceDayOfWeek(4,5) returns the number of days until the next last Wednesday of a month.