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?
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.
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.
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:
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: