No. of working days of employees.

mabubakerali

New Member
Joined
Feb 23, 2016
Messages
35
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]
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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!
 
Upvote 0
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
ABCDE

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]Joining Date =[/TD]
[TD="align: right"]01/01/2016[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Holidays[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]Leaving Date =[/TD]
[TD="align: right"]31/12/2016[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]Working Days =[/TD]
[TD="bgcolor: #D8E4BC, align: right"]314[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1



formula in cell B3
Code:
=NETWORKDAYS.INTL(B1,B2,11,E2:E5)

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

Paul.
 
Last edited:
Upvote 0
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
ABCDE

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]Joining Date =[/TD]
[TD="align: right"]01/01/2016[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Holidays[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]Leaving Date =[/TD]
[TD="align: right"]31/12/2016[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]Working Days =[/TD]
[TD="bgcolor: #D8E4BC, align: right"]314[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1



formula in cell B3
Code:
=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!
 
Last edited:
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top