Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count number of working days in selected month?

Hi.

I need to find number of working days in month I or another users selected.

With selection change, change workingdays also.

Thanks for help.

Regards Kris

4 Replies
Not applicable
Author

you have to save weekdays in you modell and the you can count like this

in this case you have to select a month:

count({<Weekday -= {'Sa','So'}>}Date)

hope this helps.

regards,

MT

Not applicable
Author

  You can try this as well.

=Count({<WeekDay-={'Sat','Sun'}>}WeekDay)

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try NetWorkDays()

Regards,

Jagan.

Not applicable
Author

Thank you for all ansvers, but it didn't help.

Selection of month and year is made in another chart and funcion give back wrong number.

Regards Kris