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