web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps DatePicker

Power Apps

Answered

DatePicker

(0) Share

Report

Report

Posted on by Marlin-A

265

Hello guys,

Just wanted to seek some help.

I have 2 date picker StartDatePicker and EndDatePicker.

I want to show on my label how many working days I've used without counting the Saturday and Sunday.
It is for a Leave Management.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @Marlin-A ,
Try this
RoundDown( DateDiff( EndDatePicker.SelectedDate, StartDatePicker.SelectedDate, Days )/7,0 ) * 5 + Mod( 5 + Weekday(EndDatePicker.SelectedDate) - Weekday(StartDatePicker.SelectedDate),5 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation