web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculating how many b...
Power Apps
Answered

Calculating how many business days are there in a relative date range

(0) ShareShare
ReportReport
Posted on by 65

Hello, everyone!
I've created a gallery in which its TemplateFill property indicates how close to ThisItem.Duedate the user is.

For this example, we'll assume Today() = 23/01/2024 in dd/mm/yyyy. So if an item's due date is 23/01/2024, their section in its gallery would be red (0 date difference). If it's 24/01/2024 it would be orange (1 day for it to expire). If it's 25/01/2024 it would be green (2 days to expire).

My problem is when this due date falls on a Sunday or Saturday, which I cannot control (These dates come from a SharePoint calculated column). Our company only works until Friday and it would be the last day of our workers to do something regarding the items expiring over the weekends, and I want to indicate this using by color. So if a Due date falls on Sunday, the section of its item will be painted green on Friday and I want it to be red. Can someone show me how to do it?

Categories:
I have the same question (0)
  • Verified answer
    Ethan_009 Profile Picture
    4,838 Moderator on at

    Hi @Calheiro ,

     

    You can take reference from this video [YouTube link]

    Once you get the info, you can set conditions for color options based on your requirement.

     

    Hope this helps

  • Calheiro Profile Picture
    65 on at

    It was a really good recommendation. I could solve my issue based on it. Thank you very much!

  • Ethan_009 Profile Picture
    4,838 Moderator on at

    @Calheiro , Happy to know that helped you 🙂

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard