Workday.INTL or Workday function issue

**junoon** · 01-16-2013, 03:39 PM

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.

**jeversf** · 01-17-2013, 12:36 PM

workday.intl.xlsx

Hi junoon,

Please see attached for one possible solution. I wrote the formula in such a way that if the date in A1 appears in the holidy list, it would increment the date by one day. I've highlight it in red on the attachment, all you need to do is replace it with a value/date that you would rather have instead.

Hope this helps.

**daddylonglegs** · 01-17-2013, 03:14 PM

You can fix the problem by making a small change to your original formula, instead of subtracting 1 from ROWS subtract it from the date like this:

=WORKDAY($A$1-1,ROWS($A$3:$A3),holiday_list)