Holiday scenario

[Anonymous]

emp_id	Sheetdate	task	Workedhours
1	1/1/2017	1	6
1	1/1/2017	2	2
1	1/1/2017	3	3
2	1/1/2017	1	1
2	1/1/2017	2	8
2	1/1/2017	3	1
1	1/2/2017	4	5
1	1/2/2017	5	4
2	1/2/2017	4	4
2	1/2/2017	5	4

i have entered in time sheet for worked hours in daily basis. if not entered  Saturday, Sunday and any other holidays. but i want to only entered worked hours for month wise per employee, not considered not entered days. if i select master calendar in month wise it will show only entered days calculate and show.  please suggest!

[adamdavi3s]

I'm not really understanding your question, but can you simply add a 'working day' flag to your master calendar and then use this?

Is your question you want to show ALL dates regardless of information entered

or

Show ONLY working dates?

[Anonymous]

Hi, use Networkdays function, you have to pass start and end date, and a list of holiday days.

Regards!!