Calculated Column in Sharepoint

Question

Hi team,

I would need help for my calculated column in Sharepoint to exclude weekends and particular dates (e.g June 12 and 17) due to holidays.

Currently, I have weekends to be excluded. Thank you! Your help is much appreciated.

=IF(WEEKDAY([Review Date])=2,[Review Date]+3,(IF(WEEKDAY([Review Date])=3,[Review Date]+3,(IF(WEEKDAY([Review Date])=1,[Review Date]+3+1,[Review Date]+3+2)))))

Answer 1

Hi @Treb Bert ,

According to your description, if the date to be excluded is certain, you can directly add a judgment based on the original formula to exclude the situation:

This is the formula I tested:

=IF(AND(MONTH([Review Date])=6,OR(DAY([Review Date])=12,DAY([Review Date])=17)),[Review Date]+1,IF(WEEKDAY([Review Date])=2,[Review Date]+3,IF(WEEKDAY([Review Date])=3,[Review Date]+3,IF(WEEKDAY([Review Date])=1,[Review Date]+3+1,[Review Date]+3+2))))

When the condition is met, I perform Review date+1, you can modify it according to your own needs.

The result:

Have a nice day!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.