Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to do computations between two dates. For example:
(monday) 01.02.16 - 29.01.16 (friday).
Unfortunately the system is giving me back the result of 3 in fact that it count the weekend in between. I want to see 1 as an result if I think in working days.
Is there as easy option to tell the system to ignore sat und sun in the computation? or the other way around on respect days from monday fto friday?
Thx for help
Heiko
Try this:
NetWorkDays(StartDate, EndDate)
In your case -> NetWorkDays(MakeDate(2016,1,29), MakeDate(2016,2,1))
Hello Sunny , thx for your great help.