Calculation of Networkingdays

[vinod1992]

Hi,

I have Oct2018,Nov2018,Dec2018 and Jan2019 data and I want to calculate the Networkingdays for Jan2019.

How can I do it?

Please help me out with your suggestion @sunny_talwar 

Thanks & Regards,

Vinod

[sunny_talwar]

Would you be able to share some sample data and the output you expect to see from it?

[Vegar]

Maybe this is what you're looking for?

Load

YearMonth,

Networkdays(monthstart(YearMonth), monthend(YearMonth)) as NoOfWorkdays

;

Load

 Date#(YearMonth, 'MMMYYYY') AS YearMonth

inline [

YearMonth

Oct2018,

Nov2018,

Dec2018 

Jan2019 ];

[VishalWaghole]

If you want to display in Text object then follow below expression.
By default you will get maximum network days count and on selection of YearMonth you will get respective month network days.

=NetWorkDays(MonthStart(Max(YearMonth)),MonthEnd(Max(YearMonth)))

Thanks,
Vishal