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 💙
-
41:23
The Why Files
2 days agoBaltic Sea Anomaly, Atlantis, and Underwater Alien Bases | Mysteries of the Ocean Pt 1
21.8K34 -
LIVE
LFA TV
5 hours agoMAGA ON THE MOVE! | LIVE FROM AMERICA 7.2.24 11am EST
5,726 watching -
LIVE
Real Coffee With Scott Adams
2 hours agoEpisode 2524 CWSA 07/02/24
1,857 watching -
2:23:55
Matt Kohrs
13 hours agoTrump Granted Immunity, Powell Speech & Market Chaos || The MK Show
14.9K7 -
1:25:23
MTNTOUGH Fitness Lab
19 hours agoTrevor Farnes: Conquering Life's Mountains
13.6K27 -
22:22
Rethinking the Dollar
2 hours agoMidlife Retirement Crisis: Why $1.8 Million Won’t Save Your Retirement Anymore!
5.91K8 -
1:00:12
2 MIKES LIVE
4 hours agoThe Mike Schwartz Show 07-02-2024
8.08K1 -
57:58
ShawnStevenson
22 hours agoNeurologist Shows You How to Avoid Cognitive Decline | Dr. Dale Bredesen & Shawn Stevenson
12.5K6 -
16:05
Standpoint with Gabe Groisman
2 hours agoEp. 34. Quick Point: The Debate on the Debate.
6.54K3 -
2:58:01
Wendy Bell Radio
7 hours agoAmerica's Masterclass Gaslighters
57.3K69