How To Use SharePoint List Calculated Column Date Formulas

This SharePoint tutorial will demonstrate how to use date formulas in a SharePoint list. Specifically, it will demonstrate how to create a SharePoint List calculated column that uses date formulas. It will demonstrate how to create a SharePoint List calculated column that calculates today or the current date. It will also demonstrate how to create a SharePoint List calculated column date difference that calculates the difference between the current date and another date field. This SharePoint calculated column days old technique is perfect for determining the age of an item or for determining the number of days until a task is due (or is overdue). It will also demonstrate how to create a SharePoint list calculated column month, which extracts the month from another SharePoint list date field. It will also demonstrate how to create a SharePoint list calculated column year that extracts the year from another SharePoint list field. It will conclude by demonstrating how to create a SharePoint List calculated column weekday that extracts and displays the name of the day of the week from another SharePoint list column and as an integer. All of the SharePoint list date formulas referenced in this tutorial have been added below for reference:
🔔SIGN UP FOR MY SHAREPOINT LIST FUNDAMENTALS COURSE🔔bit.ly/462FHc4
FORMULAS USED IN THIS TUTORIAL
SharePoint List Calculated Column Current Date Formula:
=Today()
SharePoint List Calculated Column Month Formulas:
=Text(, "MMMM") - This will return the full month name
=Text(, "MMM") - This will return first 3 letters of the month name
=Text(, "MM") - This will return integer month
SharePoint List Calculated Column Year Formulas:
=Text(, "YYYY") - This will return the year
SharePoint List Calculated Column Day Formulas:
=WEEKDAY() - Returns an integer representing the day component of the date field
Timeline:
0:00 - Start
1:05 - SharePoint List calculated column current date formula
3:30 - SharePoint List calculated column date difference formula
5:25 - SharePoint List calculated column full month name formula
7:30 - SharePoint List calculated column first 3 characters of month name formula
8:40 - SharePoint List calculated column month as an integer formula
10:20 - SharePoint List calculated column year formula
12:00 - - SharePoint List calculated column weekday formula
#Sharepoint #Microsoft365 #microsoft
MORE ABOUT ME
LOOKING FOR TRAINING OR CONSULTING - CONTACT ME AT:
bit.ly/3OLDmbh
LETS BE FRIENDSI
🔔Instagram: / luigiiacobellis
🔔LinkedIn: / liacobe
🔔Twitter: / luigiiacobellis
🔔TikTok: / luigiiacobellis
🔔Reddit: / owndirector1326
🔔Website: luigiiacobellis.com/
🔔Linktree: linktr.ee/Liacobellis
GOT A VIDEO IDEA? FILL OUT THIS FORM:
bit.ly/3yjEewm
SIGN UP FOR MY MONTHLY NEWSLETTER
📧 landing.mailerlite.com/webfor...
PRODUCTS THAT I USE TO CREATE MY KZbin VIDEOS:
⭐ Amazon StoreFront: www.amazon.com/shop/luiiacobe...
⭐USB Microphone - Yeti X: amzn.to/3QLpfVt
⭐ Web Cam -Dell UltraSharp HDR 4K: amzn.to/3HQ9TuO
⭐ Laptop - Dell XPS 9510: amzn.to/3ng1zL9
⭐ Monitor - Dell Curved 4K UHD: amzn.to/3OKjCoL
⭐ Mouse-Keyboard - Dell Premier Multi-Device: amzn.to/3OlI9kf
⭐ Lighting Kit - LimoStudio 700W Series: amzn.to/3u1V82q
SOFTWARE THAT I USE TO CREATE MY KZbin VIDEOS & CONTENT:
⭐ Screen Recording & Editing - Camtasia: bit.ly/3NmF9mf
⭐ Screenshots & Photo Editing - SnagIt: bit.ly/3NmF9mf
⭐ KZbin Thumbnails - Canva Pro: bit.ly/3nj1Rkx
⭐ Content Tracking - AirTable: bit.ly/3dYsV3H
⭐ Email Newsletter Creation - MailerLite: bit.ly/3ET6SYb
⭐ Mailing List Forms - ConvertKit: bit.ly/3xVD5ff
⭐ Social Media Scheduling - Later: bit.ly/3lgeCuW
⭐ VPN - ExpressVPN - 30 Days Free: bit.ly/3NmGUjl
⭐ Task Tracking - Trello: bit.ly/3xToX69
OTHER SERVICES THAT I USE:
⭐ ETF Investing - WealthSimple - Get $10,000 Managed Free: bit.ly/3HQF8G5
⭐ IT Training - Global Knowledge - Save 10%: bit.ly/3A6l5BG
⭐ Cashback On Online Purchased - Rakuten - Get $30 Free: bit.ly/3OmNV59
⭐ Earn Passive Income - Survey Junkie: bit.ly/3OoXwZ7
Note that I may earn a small commission at no additional cost to you from purchases made using these links.