Count of Working days

[ariel_klien]

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:

source.ACTIVITY_MM	source.ACTIVITY_YYYY
01	2013
02	2013
03	2013
04	2013
05	2013
06	2013
07	2013
08	2013

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?

BR

Ariel

[swuehl · Accepted solution]

You can use makedate() function instead of date#() date interpretation, which should make things much simpler:

=NetWorkDays(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM),

if(text(GetFieldSelections(source.ACTIVITY_MM))=text(Date(ReloadTime(),'MM')),

ReloadTime(),

monthend(makedate(source.ACTIVITY_YYYY,source.ACTIVITY_MM)))

)

[ariel_klien]

Working fine.

Thanks.