Calculated Column in Sharepoint

Treb Bert 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. Yanli Jiang - MSFT 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:

    User's image

    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.


0 additional answers

Sort by: Most helpful