No. of working days of employees.

[mabubakerali]

i want to calculate the no. of working days of employees.
and situation goes this way:
ENTER joining date in b2
ENTER leaving date in b3
and result displays in some cell.
[Working days in a year is 313 or a year will be counted as 313]

 

[ExcelBitesize]

Hi

Try the NETWORKDAYS.INTL function, it has an argument for how long the weekend is. The argument allows you to determine which days and how many of them should be treated as the weekend/non working days.

ps, this is my first post so I hope it helps!

 

[Taul]

Hi,
I agree with ExcelBitesize, NETWORKDAYS.INTL is the way to go.
If the working days are 313 for the year, then I assume you are not counting Sundays as a working day (reasonable guess), in which case I notice there are 313 day (excluding Sundays) during 2015 but 2016 has 314 days.
The function has the ability to also subtract holidays if required.


Excel 2010

	A	B	C	D	E
1	Joining Date =	01/01/2016			Holidays
2	Leaving Date =	31/12/2016
3	Working Days =	314
4
5

<tbody>
</tbody>

Sheet1​

formula in cell B3

=NETWORKDAYS.INTL(B1,B2,11,E2:E5)

The "11" indicated Sunday only is the weekend (B1,B2,11,E2:E5)

Paul.

 

[mabubakerali]

Hi,
I agree with ExcelBitesize, NETWORKDAYS.INTL is the way to go.
If the working days are 313 for the year, then I assume you are not counting Sundays as a working day (reasonable guess), in which case I notice there are 313 day (excluding Sundays) during 2015 but 2016 has 314 days.
The function has the ability to also subtract holidays if required.


Excel 2010

	A	B	C	D	E
1	Joining Date =	01/01/2016			Holidays
2	Leaving Date =	31/12/2016
3	Working Days =	314
4
5

<tbody>
</tbody>

Sheet1​

formula in cell B3

=NETWORKDAYS.INTL(B1,B2,11,E2:E5)

The "11" indicated Sunday only is the weekend (B1,B2,11,E2:E5)

Paul.

Thanks alot man thanks, it worked!

 

[mabubakerali]

Hi

Try the NETWORKDAYS.INTL function, it has an argument for how long the weekend is. The argument allows you to determine which days and how many of them should be treated as the weekend/non working days.

ps, this is my first post so I hope it helps!

Thanks buddy! it worked!