How to Fix an Incorrect February 29 Date in an Excel Calendar Template
Question details
The user needs to remove an invalid February 29 date from a 2023 Excel calendar template without breaking the sequence of the remaining dates.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Editing an annual calendar template for a non-leap year where the dates are misaligned due to an extra day in February.
- Observed behavior
- The 2023 calendar incorrectly displays February 29, causing all subsequent dates in the year to be shifted by one day.
Verify whether your calendar template uses automated date formulas or static text entries before attempting to delete or shift any cells, as deleting formula-driven cells will cause #REF! errors.
Replace the Template with a Correctly Configured Calendar
The safest and most reliable method is to use a calendar template designed with dynamic formulas that automatically account for leap years.
Manually deleting a day and shifting the remaining dates by one cell is highly discouraged. Doing so in a formula-based template will break the cell references, while doing it in a static template is tedious and prone to formatting errors.
Open Excel or WPS Spreadsheet, go to the 'File' menu, select 'New', and type 'Calendar' into the template search bar.
Look for a yearly calendar template that allows you to input the year at the top. Click 'Create' or 'Use Now' to open it.
Click on the designated year cell (usually at the top of the sheet) and type '2023' or your current year. Press Enter. The dates will automatically adjust to exclude February 29 if it is not a leap year.
Copy your custom events from your old calendar and paste them into the corresponding correct dates in the new template using 'Paste as Values'.

Correct the Year Reference in Date Formulas
If you prefer to keep your current template, ensure that its underlying base year formula is accurately pointing to the non-leap year.
Create Flawless Calendars Automatically with WPS Office
Stop struggling with broken calendar dates. WPS Spreadsheet provides an extensive library of dynamic, beautifully designed calendar templates that automatically adjust for leap years and starting days, saving you from manual data entry.
- 1. Open WPS Spreadsheet: Launch WPS Office on your computer and select 'Spreadsheet' from the main dashboard.
- 2. Access the Template Library: Click on 'New' in the left-hand panel, then browse the 'Templates' section and search for 'Yearly Calendar'.
- 3. Apply a Dynamic Template: Select a template you like and click 'Use Now'. The calendar will open in a new tab.
- 4. Customize the Year: Simply type '2023' (or any non-leap year) into the master year cell, and watch the entire calendar perfectly align without any incorrect February 29 dates.

Frequently Asked Questions
Why does my Excel calendar template show February 29 for a non-leap year?
This usually happens because the template relies on static text copied from a leap year calendar, or its underlying date formula is hardcoded to a leap year (like 2020 or 2024) instead of referencing the actual specified year.
Can I just delete the February 29 cell and shift the rest of the dates up?
It is not recommended. If the calendar uses formulas to calculate dates, shifting cells will create reference errors (like #REF!). If it is static text, shifting cells manually often misaligns the days of the week for the rest of the year.
How do I make an Excel calendar formula automatically adjust for leap years?
You can use the EOMONTH function to determine the last day of February. For example, '=DAY(EOMONTH(DATE(A1,2,1),0))' (where A1 is the year) will return 29 if it's a leap year and 28 if it's not, allowing you to hide or show the 29th dynamically.




