Net work Days in current month

[#1]

Hi Guys

I want to count average sales per day. I am counting total sales for the current month by using following expression.

=Count(DISTINCT(if(Month([Completion Date]) = Month(Today()), OrderId)))

How to get number of total working days in present month? to divide with above expression

Thanks

[sunny_talwar]

May be like this:

NetWorkDays(Floor(MonthStart(Today())), Floor(MonthEnd(Today())))

[#3]

Thanks Sunny...

Your expression is giving me total as 23

how do I exclude weekends?

thanks

[sunny_talwar]

I think weekends are already excluded here

[sunny_talwar]

I see 23 weekdays in the month of August

!

[#6]

Because today is 23 August and if you subtract 6 weekends then it should give you total as 17 !

[#7]

oh now i got your point lol... i wanted MTD weekedays

sorry for confusion

[sunny_talwar · Accepted solution]

May be this:

NetWorkDays(Floor(MonthStart(Today())), Today())