SharePoint list Calculate a date from an existing date field for Working/Business days

SharePoint list Calculate a date from an existing date field for Working/Business days

SharePoint list - Add column automatically calculating date from an existing date field - For Working Days/Business Days - This formula ignores weekends and only works on Business days.

👀 Link to Weekday documentation:
👉 https://support.microsoft.com/en-us/office/weekday-function-f0aa7aa6-fad7-4e41-aab9-3e77a133f0be

The formula used for calculating 2 business days in advance:
=IF(WEEKDAY([Created Date 1])=1,[Created Date 1]+2,
IF(WEEKDAY([Created Date 1])=2,[Created Date 1]+2,
IF(WEEKDAY([Created Date 1])=3,[Created Date 1]+2,
IF(WEEKDAY([Created Date 1])=4,[Created Date 1]+2,
IF(WEEKDAY([Created Date 1])=5,[Created Date 1]+4,
IF(WEEKDAY([Created Date 1])=6,[Created Date 1]+4,
IF(WEEKDAY([Created Date 1])=7,[Created Date 1]+3)))))))

👉 Hey welcome to WeTechCareOfYou!
If you are a returning subscriber we wish to say thankyou!
If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email [email protected] or complete a form here: https://wetechcareofyou.com/contact/
Kind Regards,
The WeTechCareOfYou Team 💙