Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rawatn
Contributor
Contributor

Working Days in a Month (MiddleEast)

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,

Labels (1)
1 Solution

Accepted Solutions
rawatn
Contributor
Contributor
Author

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.

View solution in original post

1 Reply
rawatn
Contributor
Contributor
Author

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.