Weekly schedule template in excel
In this post I have created a simple weekly schedule in excel.
How to use weekly schedule
- Type any date in in cell F2 and press Enter.
Now what?
All dates in chosen week are dynamically updated. See cell range C4:I4.
Why?
You can easily create and print multiple weekly schedules quickly without editing each date in week.
Download excel template
Create a weekly schedule.xls
(Excel 97-2003 Workbook *.xls)
Formula in C4:
=$F$2-WEEKDAY($F$2;1)+1 , Press ENTER
Formula in D4:
=C4 + 1 Press ENTER. Copy cell D4 and paste on cell range E4:I4.
Added features
- How to highlight specific time ranges
- How to find empty hours
- How to populate cells dynamically
- Setting up your work hours
- Schedule recurring events in a weekly schedule in excel
What features would you like to be added?







August 26th, 2011 at 8:11 pm
Thank you for this!! It was simple and helped me so much!! I made it work for me. Thanks again!
August 28th, 2011 at 5:14 pm
Megan,
You are welcome!