count number of workdays this month from today

[#1]

Hi,

I need to count the number of workdays in the current month from Today.

I was thinking that the today function would return today's date, and that would tell QlikView what month we were in, and then somehow the formula would count the number of workdays UP TO today's date, and then return a number.

Is this possible?

Thanks, JV

[anbu1984 · Accepted solution]

=NetWorkDays(MonthStart(Today()),Today())

[jagan]

Hi,

Try like this

=NetWorkDays(MonthStart(Today()),Today())

Check the syntax of the function: From Qlikview Help file

networkdays (start:date, end_date {, holiday})

Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

Examples:

networkdays ('2007-02-19', '2007-03-01') returns 9 

networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

Regards,

Jagan.

[#4]

Perfect!  Thanks.