Create a dynamic team tracker calendar in Excel which updates automatically as you specify the month and year. The conditional formatting automatically highlights the weekend columns saving time over doing it manually.

This quick tutorial video will show you how to use features and functions such as:

Conditional Formatting based on another cell
Weekday Function
Date Function
Drop Down Lists

Feel free to like and subscribe!

00:00 How It Works
00:53 Excel Calendar Templates
01:34 Create Drop Down List
03:45 Dynamic Dates
04:52 Format Dates
06:42 Add Names
07:00 Format Calendar
08:12 Weekday Function
09:50 Weekday Absolute Reference
10:56 Conditional Formatting
12:25 Final Calendar
12:58 Thanks For Watching

#excel #tutorial #teamcalendar