Premium Only Content

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 💙
-
LIVE
LFA TV
13 hours agoLFA TV ALL DAY STREAM - THURSDAY 7/31/25
4,756 watching -
LIVE
JuicyJohns
3 hours ago $1.15 earned🟢#1 REBIRTH PLAYER 10.2+ KD🟢$500 GIVEAWAY SATURDAY!
105 watching -
43:09
VINCE
2 hours agoSPECIAL: "Obamagate" DEEP-DIVE with Gen. Mike Flynn, Mike Benz and Paul Sperry
39.4K58 -
LIVE
The Big Mig™
3 hours agoFBI Burn Bags, Hidden SCIF’s & Truth About Mar-A-Lago Raid
5,145 watching -
1:50:11
Dear America
3 hours agoFBI Discovers THOUSANDS Russia Hoax Docs In “Burn Bags”!! + Pelosi EXPOSED For Insider Trading!!
103K75 -
1:27:12
Tucker Carlson
2 hours agoTony Aguilar Details the War Crimes He’s Witnessing in Gaza
71.6K112 -
LIVE
Badlands Media
5 hours agoBadlands Daily: July 31, 2025
4,312 watching -
2:16:31
Matt Kohrs
12 hours agoHUGE Earnings Beat, Inflation Data & New Record Highs || Live Trading Options & Futures
28.7K2 -
19:44
Bearing
3 hours agoWorld’s CRAZIEST Feminist Wants AMERICANS to WAKE THE F*** UP 🦅💥
18.2K35 -
47:09
Randi Hipper
1 hour agoUNITED STATES BITCOIN RESERVE IS COMING! WHITE HOUSE CRYPTO REPORT EXPLAINED
16.4K2