Date perfection with Excel tips and tricks - Step 2

Welcome to another Excel video! This is Step 2 on how Excel can help with dates and how to build dynamic calendars. Our step-by-step guide continues with the build of our dynamic calendars with supporting date calculations.
#excel #exceltricks #neurodiversity #microsoft #fyp #dates #datefunction #excelformula #visualbasic #calendar

Delivered by @Changetipsandtools

This video contains:
00:00 - Intro
00:35 - Build data elements to support dynamic Calendars
03:18 - Keyboard shortcut for today's date (Tips and Tricks)
04:36 - Use YEAR Function to calculate the Year for the selected month
05:00 - Use MONTH Function to calculate selected month
05:18 - Calculate the Year value for the previous and next month
07:28 - Calculate the Month value for the previous and next month
09:44 - WEEKDAY Function explained
10:41 - Use the WEEKDAY and DATE Functions to calculate the day of the week that the month starts on
12:58 - Use the IFS, ISNUMBER & AND functions together to calculate adjustment date
21:41 - Data requirements completed, we can now start building our calendars
22:00 - Create Days of the week headers
22:13 - Use the IF, DATE, MONTH and SEQUENCE functions to generate calendar
25:30 - Format our calendar to actually look like a calendar
28:42 - Build a dynamic title for your Calendar using the TEXT Function
33:39 - Use Conditional Formatting to highlight key days e.g. Today's date
39:05 - Use Find & Replace to change formulas quickly!