Given a certain beginning date and specified number of days, one may want to determine the ending date (beginning date plus number of days). When determining the ending date, the following two cases should be considered
Case 1
Holidays are:
1. Sundays only; and
2. User specified public holidays
Case 2
Holidays user specified public holidays only. Saturdays and Sundays are working days
If the landing date is any of the two holidays, the result should be the next working day.
You may refer to my solution in this workbook.
Determine weekday after factoring in user specified holidays
{ 0 Comments }