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:

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:
https://bit.ly/3OLDmbh

LETS BE FRIENDSI
🔔Instagram:   / luigiiacobellis  
🔔LinkedIn:   / liacobe  
🔔Twitter:   / luigiiacobellis  
🔔TikTok:   / luigiiacobellis  
🔔Reddit:   / owndirector1326  
🔔Website: https://luigiiacobellis.com/
🔔Linktree: https://linktr.ee/Liacobellis

GOT A VIDEO IDEA? FILL OUT THIS FORM:
https://bit.ly/3yjEewm

SIGN UP FOR MY MONTHLY NEWSLETTER
📧 https://landing.mailerlite.com/webfor...

PRODUCTS THAT I USE TO CREATE MY YOUTUBE VIDEOS:
⭐ Amazon StoreFront: https://www.amazon.com/shop/luiiacobe...
⭐USB Microphone - Yeti X: https://amzn.to/3QLpfVt
⭐ Web Cam -Dell UltraSharp HDR 4K: https://amzn.to/3HQ9TuO
⭐ Laptop - Dell XPS 9510: https://amzn.to/3ng1zL9
⭐ Monitor - Dell Curved 4K UHD: https://amzn.to/3OKjCoL
⭐ Mouse-Keyboard - Dell Premier Multi-Device: https://amzn.to/3OlI9kf
⭐ Lighting Kit - LimoStudio 700W Series: https://amzn.to/3u1V82q

SOFTWARE THAT I USE TO CREATE MY YOUTUBE VIDEOS & CONTENT:
⭐ Screen Recording & Editing - Camtasia: https://bit.ly/3NmF9mf
⭐ Screenshots & Photo Editing - SnagIt: https://bit.ly/3NmF9mf
⭐ YouTube Thumbnails - Canva Pro: https://bit.ly/3nj1Rkx
⭐ Content Tracking - AirTable: https://bit.ly/3dYsV3H
⭐ Email Newsletter Creation - MailerLite: https://bit.ly/3ET6SYb
⭐ Mailing List Forms - ConvertKit: https://bit.ly/3xVD5ff
⭐ Social Media Scheduling - Later: https://bit.ly/3lgeCuW
⭐ VPN - ExpressVPN - 30 Days Free: https://bit.ly/3NmGUjl
⭐ Task Tracking - Trello: https://bit.ly/3xToX69

OTHER SERVICES THAT I USE:
⭐ ETF Investing - WealthSimple - Get $10,000 Managed Free: https://bit.ly/3HQF8G5
⭐ IT Training - Global Knowledge - Save 10%: https://bit.ly/3A6l5BG
⭐ Cashback On Online Purchased - Rakuten - Get $30 Free: https://bit.ly/3OmNV59
⭐ Earn Passive Income - Survey Junkie: https://bit.ly/3OoXwZ7

Note that I may earn a small commission at no additional cost to you from purchases made using these links.