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.
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.