Working Day in the Month

[stuwannop]

Hi All

I'm building a report for cash collection and I'm struggling to figure out how to report the following (ideally I can just drop this into my master calendar script):

What I want is the WORKING Day Number in the month. I suspect the NetworkDays function comes in here but I'm not sure how to report the Working Day Number - for example (in uk date format):

01/03/2013 (Friday 1st)        = 1

02/03/2013 (Saturday 2nd)   = NULL

03/03/2013 (Sunday 3rd)     = NULL

04/03/2013 (Monday 4th)      = 2

05/03/2013) (Tuesday 5th)    = 3

etc. etc.

Thanks for any help.

Stu

[nagaiank]

Attached is a solution using NetWorkDays() function.

[kaushiknsolanki]

Hi,

     Have a look at the attached application for solution.

     The logic used is, you flag everyday as 1 except Sat and Sunday. Then you sum up the flag values to get the total number of days.

     Hope its clear.

Regards,

Kaushik Solanki