How to customize a weekly planner template in Excel. We'll transform a weekly lesson planner template in Excel for teachers, and turn it into a weekly project planner for work. See how to auto-populate dates and generate multiple weekly tabs at once. Use the new Excel checkboxes to apply custom formatting, and see how to set up an index table of contents tab for easy weekly planner workbook navigation with hyperlinks.

Use this template for any type of weekly planner, even for personal things like household chores, or a meal planner. We'll generate a new set of weekly tabs for next year so you can see how to repeat this and reuse the template each year.

You can purchase both the Weekly Lesson Planner and Weekly Project Planner templates to get a jump start: https://creatoriq.cc/3AqqOF3

TIMESTAMPS
00:00 Weekly Planner Template in Excel
00:39 Excel Weekly Planner Key Features
02:43 Customize Weekly Planner to Project Plan
04:56 Create New Index Table of Contents in Excel
07:18 Insert Icon to Hyperlink Back to Index Sheet
08:34 Create Macro to Generate Each Weekly Sheet

FREE COURSE: How To Create Fillable Forms in Microsoft Word - A Step-by-Step Guide
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro!
https://youtu.be/438pCPCSuG4

WATCH NEXT Create an Inventory List Template in Excel: https://youtu.be/GYChuAor3Zk

CHANNEL LINK
https://www.youtube.com/@SharonSmith
Visit my Channel page on YouTube to see all my videos, playlists, community posts and more!

TEMPLATES
Check out my helpful list of templates available for purchase: https://creatoriq.cc/43c51cv
Thank you for supporting my channel!

FREE DOWNLOADS
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.

CONNECT WITH ME
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearning/
Facebook: https://www.facebook.com/SharonSmithLearning

GEAR
Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
Green Screen: https://amzn.to/2DnHsY2
Camera: https://amzn.to/39KvpQA
Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)

RESOURCES
JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
TechSmith Camtasia Screen Recording: https://techsmith.z6rjha.net/SharonSmithHR

Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!

SUPPORT THIS CHANNEL
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url

If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much!

We use the following VBA code in this video to generate the 52 weekly tabs in our Excel Weekly Planner template:

Sub DuplicateSheetAndUpdateDates()
Dim i As Integer
Dim ws As Worksheet
Dim startDate As Date
Dim nextMonday As Date

' Define the starting date from Sheet1's C6 cell (first Monday date)
startDate = Sheets("Sheet1").Range("C6").Value
nextMonday = startDate

' Loop to duplicate the sheet 52 times
For i = 1 To 52
' Duplicate the sheet
Sheets("Sheet1").Copy After:=Sheets(Sheets.Count)

' Set the new sheet as the active sheet
Set ws = ActiveSheet

' Rename the sheet as "Week X"
ws.Name = "Week " & i

' Update cell C6 with the next Monday
ws.Range("C6").Value = nextMonday

' Calculate the date for the following Monday
nextMonday = nextMonday + 7
Next i
End Sub

PLAYLISTS
Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD

Excel Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel Tips & Tricks: https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW