# How to query to Calculate employee number of working days from Dat of Joining. RSS

Last post Dec 18, 2014 09:36 PM by Edwin Guru Singh

Member

150 Points

605 Posts

### How to query to Calculate employee number of working days from Dat of Joining.

I am struggling with the query.

i have below record to query to calculate the employee working days from date of joining.

 Emp.No Date of Joining Total Days No.of Worked Days (public holidays & Sat and Sundays) Total Days Total Days (Including Holidays) 101 1-Jan-14 220 220 60 220 220 + 60 = 280 102 1-Feb-14 220 190 55 190 190 + 55 = 245 103 1-Mar-14 220 170 50 170 170 + 50 = 220

i want query that calculates the no.of working days,public holidays and it should calculate from date of joining.

because the public holidays will get reduced it it may vary for every employee while we taking from Date of joining

how to form a query..?

Star

8536 Points

1376 Posts

Microsoft

### Re: How to query to Calculate employee number of working days from Dat of Joining.

Dec 18, 2014 09:36 PM|Edwin Guru Singh|LINK

Hi ,