I struggle to understand how NETWORKDAYS function can be used. I read the help page for the function but in vain.
I want to get number of working days in Jan 2023 (ignoring holidays).
My formulas is:
NETWORKDAYS(date(2023,1,1),date(2023,1,31),'01. Day of week'.Working = true)
where Day of week is a dimension I created (below).
I am getting 150 as the result of the formula which is obviously wrong. Help please :)
Best answer by Issam MoallaView original