Announcements
In my leave request app, I have a request screen which correctly calculates the days requested excluding weekends and company holidays. I've added a calendar to view approved requests, but need exclude the 'circle' being visible on weekends and company holidays. How can I achieve this please?
Hi,
weekday() returns day number from date ,for example monday=0. Based on that you should be able to hide circle if day number equals number representation of saturday/sunday
@Woxax - thanks for your suggestion, I'd wondered the same but can't get the formula right - any ideas?
HI, sorry, didnt see your reply
just change YourDate to date prvided by galllery item and it will work
!(Weekday(YourDate,StartOfWeek.Monday) in [6,7])
BR
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 220 Super User 2026 Season 2
WarrenBelz 189 Most Valuable Professional
Mohsin Ali 139