Calculation of Networkingdays for Current Month

[vinod1992]

Hi All,

I have 5 months of data and I want to calculate the Networkingdays of current month.

How can I do it?

Please help me out with your valuable suggestions.

Thanks & Regards,

Vinod

[Channa · Accepted solution]

use NetworkingDays function

like

=NetWorkDays(MonthStart(Today()),MonthEnd(Today()))

if you have public holidays add all holidays into variable 

=NetWorkDays(MonthStart(Today()),MonthEnd(Today()),Variable)

[vinod1992]

Thanks Channa it worked