How to Remove Year From Date in Excel?

Excel is an effective tool for managing and analysing data, but working with dates may occasionally be challenging, particularly when you need to extract particular details like the year, month, or day. This step-by-step tutorial will show you how to remove the year from a date in Excel using a variety of techniques. This course will provide you the skills to handle dates effectively, whether you wish to clean up your data for better visualisation or conduct calculations without the year component.

Whether you're a novice or a seasoned Excel user, this course is made to be simple to follow and will give you useful tips for properly handling dates. So, let's get started and master the art of removing years from dates in Excel!

Remove Year From Date

Here we will first use a formula to get any one of the values, then use the autofill handle to complete the task. So let us see a simple process to know how you can remove a year from a date in Excel.

Step 1

Consider an Excel sheet where you have a list of dates with date, month and year.

First, click on an empty cell, in this case cell C2, and enter the formula as =TEXT(A2,"mm/dd") and click enter to get the value. In the formula, A2 is the cell containing the original data.

Empty Cell > Formula > Enter.

Step 2

Then drag down using the autofill handle. Then you will see that year removed from the dates.

This is how you can remove the year from the dates in Excel.


In this tutorial, we have used a simple example to demonstrate how you can remove the year from a date in Excel to highlight a particular set of data.

Updated on: 13-Sep-2023


Kickstart Your Career

Get certified by completing the course

Get Started