# Calculated Column in Sharepoint

60 Reputation points
2024-06-06T06:46:05.42+00:00

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)))))

``````
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,012 questions
{count} votes

Accepted answer
1. 22,656 Reputation points Microsoft Vendor
2024-06-07T06:51:26.58+00:00

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.