Sharepoint list

(0) Share

Report

Posted on by Dev194

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.

@Reza

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Luis Arellano 247 on at

Like (0)

Report
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