web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Calculate working days...

Power Apps

Unanswered

Calculate working days from todays date from a variable in hours

(0) Share

Report

Report

Posted on by Community Power Pla...

I need a label or textbox to display

from a calculation so many days from todays date based on a hour value("dwn_Tasks.Selected.ServiceLevel_hours") in a dropdown

Excluding weekends

(8 hour working day)

So if the value from the dropdown is 72 hours(4 days)from todays date ;

the date displayed would be 2020-7-13 yyyy-m-d

Thanks

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

JayMagness 1,663 on at

Like (0)

Report

HI,

Here is the weekdays document for PowerApps..

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datetime-parts

here is the document on SharePoint Formulas...
http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Hi @Anonymous ,

I feel confused with your requirement:

Why do 72 hours mean 4 days? Is it a mistake

What is the start day of the week? Sunday, isn't it?

If my assumption is right, Please try to set the Text property of label as follows,

Text( DateAdd( Now(), dwn_Tasks.Selected.ServiceLevel_hours/24 + 2 * If( (Weekday( Now(), StartOfWeek.Sunday ) + dwn_Tasks.Selected.ServiceLevel_hours/24) > 5, RoundDown( (dwn_Tasks.Selected.ServiceLevel_hours/24 - (5-Weekday( Now(), StartOfWeek.Sunday ))) / 5, 0 ) + 1 ) ), "[$-en-US]yyyy-m-d" )

Hope this helps.

Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-siky-msft,
Sunday may be the first day of the week, but is not considered a workday. Nor Saturday.

But thanks will test the formula.

Dave

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Great! and thanks. I can work with this.
dave

Was this reply helpful? Yes No

Join the conversation