Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a question about the formula "networkdays()".
I have a calendar with %Date and Year and in the script the holidays defined as variable.
I would like to select a year and have the days calculated from the beginning of the selected year.
I tried this formula: networkdays(YearStart(%Datum), today() ,vHolidays). Unfortunately the (YearStart(%Datum) does not work in the function.
But the formula = networkdays(YearStart(today()), today() ,vHolidays) works. But I want to filter with the year.
I hope you can help me. Kind regards Ahmad.
Try like:
networkdays(YearStart(Max(%Datum)), today() ,vHolidays)
Thank you so much for your help. It worked directly. 😀