Count of working Days

ariel_klien — Tue, 13 Aug 2013 08:45:01 GMT

Hello all experts,

my problem is that I want in his function to extract the Number of Working day for the selected month.

my filed are:

this is my function:

=NetWorkDays(date#('01/'&source.ACTIVITY_MM&'/'&source.ACTIVITY_YYYY,'DD/MM/YYYY'),

if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),date(ReloadTime(),'DD/MM/YYYY')),

date#(

day(monthend(date#'01/'&max(GetFieldSelections(source.ACTIVITY_MM))&'/'&source.ACTIVITY_YYYY,'DD/MM/YYYY')))

&'/'&source.ACTIVITY_MM&'/'&source.ACTIVITY_YYYY))

For example if I chose MM=02, YYYY=2013 then the function will return 28,

if I chose MM=07, YYYY=2013 then the function will return 31,

if I chose MM=08, YYYY=2013 then the function will return 9 -( until the reload time)

Sadly it isn't working.

Any Idea?

Ariel

Re: Count of working Days

swuehl — Tue, 13 Aug 2013 08:48:07 GMT

Please, no cross postings. It makes it hard to follow a discussion.

Most forum users watch most of the discussion groups anyway, I think.

See your other thread a for suggested solution.

ariel_klien — Tue, 13 Aug 2013 08:50:25 GMT

The Answer: