Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share some sample data and the output you expect to see from it?
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 ];