PDA

View Full Version : Solved: Show the working days without holidays



ms06f
03-08-2013, 11:31 AM
Help me please!
I have time table in worksheet1
When I entered Start day in C2, Working Days in B column[/URL]
Question 1: what formula can do that, show the End day at D2 and
Question 2: what Formula can show the next working day at C3.

All Holidays data entered into holidays table F column[URL="http://hk.dictionary.search.yahoo.com/search?p=column&ei=utf-8#variation"] (http://hk.dictionary.search.yahoo.com/search?p=column&ei=utf-8#variation).
Working days Only Mon to Fri.

Bob Phillips
03-08-2013, 12:24 PM
Try

=WORKDAY(C2,B2,$F$2:$F$8)

ms06f
03-09-2013, 02:30 AM
In my work, Thank you so much!