# of Working Days MTD

[#1]

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]

[cesaraccardi · Accepted solution]

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 ]'