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 Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/
Kind Regards,
The WeTechCareOfYou Team 💙
-
58:43
The Nima Yamini Show
16 hours agoTank Sinatra X Ashley Mae X Nima Yamini
4.48K5 -
18:16
Man in America
19 hours agoBREAKING: MASSIVE Shorts on $DJT Stock Day Before Assassination Attempt [CLIP]
13.1K52 -
16:30
GameLeap RAID Shadow Legends
16 hours agoTop 10 BEST FREE CHAMPIONS You MUST GET in Raid: Shadow Legends 2024 (Legendary and Epic)
4.01K3 -
37:21
Destene and Brandon
15 hours agoDoctors Visits, Weird Cravings, Amazon Skincare Haul | Destene and Brandon | VLOG
3.07K1 -
31:02
ThatStarWarsGirl
14 hours agoWoke NIGHTMARE! The Acolyte Is Absolutely INSANE!
4.88K5 -
11:10
Guns & Gadgets 2nd Amendment News
1 day agoBREAKING: Supreme Court Addresses Assault Weapons Ban & Sensitive Places Ban
5.71K18 -
31:54
Degenerate Plays
13 hours agoIn Defense Of Attack Of The Clones - Call Of Duty Modern Warfare Remastered : Part 13
4.52K -
4:04:15
Steven Crowder
16 hours agoRNC Mega Live Stream 2024 | The Trump Takeover Begins
609K670 -
7:08:45
The Charlie Kirk Show
14 hours agoDonald Trump is BACK: Live at the Republican National Convention, Day 4
341K214 -
26:54
Breaking Points
12 hours ago7/18/24 BREAKING: Biden Out THIS WEEKEND Per Report
104K36