Hi,
I am using Workday.INTL function to determine a list of working days (excluding Saturdays & Sundays) for all 12 months listed in a particular column B, starting from a particular day say, Today() in Cell A1. I have a list of holidays in a column E. Workday.INTL function uses the holiday list to determine each working day starting from the day in cell A1.
The problem arises when the starting date in Cell A1 is a Holiday that is entered in the Holiday list. Workday still recognizes this date as a working day and displays it in the Column B date list.
I have attached a sample book illustrating my problem. Can someone advise on why this is happening & an alternative way to overcome this problem?
Thanks in advance.
Bookmarks