Line graph showing days in month

[joshrussin]

Hey everyone,

I am trying to make a graph that shows how many workdays are in a month per month.

This is the formula I am using to find workdays in month.

=NetWorkDays(MonthStart(Max(Date)), MonthEnd(Max(Date)), $(vHolidays))

when I put it into the graph it only shows the value for the current month into all months. I tried without Max and then the line just disappears.

[joshrussin · Accepted solution]

After looking at this a little closer, I was able to figure out I was using the wrong "Date" in the expression. The correct formula for this was...

=NetWorkDays(MonthStart(Max(Date_Dash)), MonthEnd(Max(Date_Dash)), $(vHolidays))