Publishers of the world’s most comprehensive and up-to-date Excel tutorials

## 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.

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.

## 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.

### Excel formula to get working days between two dates excluding holidays

This article shows you how to calculate the number of working days between two dates in Excel using the NETWORKDAYS function.

### Why won’t the format change for a date?

This article explains why you may not be able to format a date in Excel and shows how to solve the problem using a formula and custom format.

This article shows how to add leading zeros to numbers in Excel by using a custom format or by formatting numbers as text.

### 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.

### Excel formula to get number of days in a month

This article will show you how to create an Excel formula that calculates the number of days in the month for any given date.