web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sharepoint list

Power Apps

Answered

Sharepoint list

(0) Share

Report

Report

Posted on by Dev194

6

Hi All.

I have a sharepoint for issue tracker for my team.. All I want is to create a date column which will be a calculated field based on created date. (That will exclude weekends)

If created date is 1st january then due date will be 1st jan+ 2 days = 3rd january.

Incase 1st Jan is on Friday then due date will be 5th January ( excluding Sat and Sun day).

Please help me to create this column in sharepoint.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Luis Arellano 247 on at

Like (0)

Report
Copy link

Link copied!
Hi, you can try something like this

=IF(WEEKDAY(Created+2,2)>5,Created+4,Created+2)

EDIT: Misread your requirement, I have updated the screenshot and formula

Was this reply helpful? Yes No

Join the conversation