web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Weekdays Date Picker

Power Apps

Answered

Weekdays Date Picker

(1) Share

Report

Report

Posted on by NanaAqilla

16

Any help to calculate weekdays only between 2 date using date picker? I don't want to include weekends.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

iAM_BA 145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @NanaAqilla
You can use RoundDown function for this. In detail you can find out in following link.

https://devoworx.net/powerapps-business-days-between-two-dates/

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
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NanaAqilla ，

Please try:

With( { StartDate:Date(2023,4,5), EndDate:Date(2023,4,11) }, Sum( ForAll( Sequence(DateDiff(StartDate,EndDate,TimeUnit.Days)+1,0,1), If( Weekday(DateAdd(StartDate,Value,TimeUnit.Days))=1 || Weekday(DateAdd(StartDate,Value,TimeUnit.Days))=7, {Count:0}, {Count:1} ) ), Count ) )

Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation