# of Working Days MTD

Tue, 07 Aug 2012 16:50:41 GMT

I am trying to write a formula that gives me the number of working days that the current month has already had. I would like it to be based off of the current month and not have to rely on someone selecting a date.

The Goal is to have that in a banner at the top of my dashboard so that it is a quick reference of how far we are into the month.

This is a puicture of what I am trying to build

What it needs to say though is "Current Through 08/06/12 [4 / 23 Working Days / 17% Completed]

Re: # of Working Days MTD

cesaraccardi — Tue, 07 Aug 2012 17:56:24 GMT

Hi, simply put this in a text object:

='Current Through ' & today() & ' [ ' & NetWorkDays(MonthStart(Today()),Today()) & ' / ' &
NetWorkDays(MonthStart(Today()),MonthEnd(Today())) & ' Working Days / ' &
num(NetWorkDays(MonthStart(Today()),Today())/
NetWorkDays(MonthStart(Today()),MonthEnd(Today())),'#.##0 %')
 & ' Completed ]'

topic Re: # of Working Days MTD in QlikView

# of Working Days MTD

Re: # of Working Days MTD