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

What features would you like to be added?