Working Days in a Month (MiddleEast)

[rawatn]

Hi Team,

I am developing a sales dashboard. I need to calculate number of days in a month.

The weekend is only Friday. So I need to calculate Saturday to Thursday as working days.

No holidays.

Regards,

[rawatn · Accepted solution]

NetWorkDays(MonthStart(Today()+2),MonthEnd(Today())+1)) + (Div(WEEKDAY(Monthstart(today())-6)+1-Monthstart(today())+Floor(MonthEnd(today())),7)))
)*(networkdays(MonthStart(Today())+1,today()+1))

This gives me number of working days including Saturday. Excludes only Friday as weekend.