How to remove year from date in Excel?

Supposing you have a worksheet with all the company employees’ birthday information in it, and you want to remove the year from birthday information for keeping the privacy of employees. How do you easily remove the year from the date?

Remove year from date with formula

Remove year from the date with Kutools for Excel

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

Learn more Free download

Remove year from date with formula

There are some formulas for us to remove year from date, such as “=TEXT(A1,"mm/dd")” and ” =DAY(A1)&"/"&MONTH(A1)”. A1 is a variable, and it can be changed as possible.

You can use the formulas as this:

Select a cell adjacent to the date, and enter the formula into it. Then tap the Enter key. And the year has been removed from the date. Then select the cell again, drag the fill handle over the range of cells that you want to contain this formula.

Remove year from the date with Kutools for Excel

If you don’t know the formulas, Kutools for Excel can help you solve this problem. Using the Kutools for Excel to remove year from date, you may have to process two major steps:

A: Quickly apply a date format without year to a range of date with Apply Date Formatting tool;

B: Apply the Fill Cell with Displayed Values tool to actually remove the year.

Kutools for Excel: with more than 100 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now.

If you have installed Kutools for Excel, please do as following steps:

1. Select the date range you want to delete the year.

2. Click Kutools > Date Tools > Apply Date Formatting, and an Apply Date Formatting dialog box will display. See screenshot:

doc-remove-year-from-date1

3. Then select one date format type which just contains day and month, and click OK.

4. All of the date formats have been changed.

5. Go on click Kutools > Modify > Fill Cells with Displayed Values, and all of date have been changed to displayed values. At the same time, the years have been removed from the date. See screenshot:

doc-remove-year-from-date2