Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2019, 2016 and Mac versions more…

How to create an auto-updating Calendar Sheet in Excel

We offer a full book and e-book showing how to create an automatically updating Excel calendar in our Excel 2016 Construction Kit #1: Calendar and Year Planner Books and E-books.

Here is a screenshot from the full Calendar and Year Planner course:

The Construction Kit course teaches you everything you need to know to create this fully-featured calendar and year planner in Excel, taking you through the whole process of creating it step by step.

If you need to create a system of this kind you would greatly benefit from the Construction Kit Books and E-Books.

Creating a basic calendar

Creating a basic calendar is easy if you understand Excel’s system of Date Serial Numbers. These are explained in depth in our Excel Essential Skills Books and E-books.

Displaying events in the calendar can be done using the VLOOKUP function, which is covered in our Excel Expert Skills Books and E-books.

You can download a basic example here.

For more advanced calendars you might find the  Excel 2016 Construction Kit #1: Calendar and Year Planner Books and E-books useful, but you could also find that Pivot tables offer an easier way to summarize by date.

Pivot tables are covered in depth in our Expert Skills Books and E-books.

Share this article

Share on facebook
Share on twitter
Share on linkedin
Share on stumbleupon
Share on email

Recent Articles


Excel SEQUENCE Function

This tutorial uses a single Excel SEQUENCE function to create a perpetual calendar. Includes sample files and a step-by-step guide.

Calculating loan payment dates

Calculating Loan Payment Dates

This article shows how to calculate loan payment dates in Excel, using a formula that can calculate loans of any length and number of periods.

Leave a Reply

Your email address will not be published.

Which tutorial do you need?