Tweak WORKDAY formula

**Tejas.T** · 06-25-2014, 06:54 PM

Hi All,

Is it possible to tweak the WORKDAY formula or any other formula/way to accomplish this?

Basically while calculating WorkDay, I need to ignore a list of Holidays as well as one or more days of the week.

So for example I may way to ignore Wednesday & Saturday.

I tried for WORKDAY.INTL but it allows to ignore any two consecutive days only.

Thanks in Advance,
Tejas

**TMS** · 06-25-2014, 07:02 PM

http://office.microsoft.com/en-gb/ex...005209339.aspx

Put every Wednesday in the holiday list

Regards, TMS

**Tony Valko** · 06-25-2014, 07:05 PM

To define the weekends as Wednesday & Saturday:

=WORKDAY.INTL(A2,10,"0010010")

0 means to include this weekday as a workday
1 means to exclude this weekday as a workday

The string of 0s and1s is 7 long with the first digit representing Monday and the 7th digit representing Sunday.