# How to Remove a Year from a Date in Microsoft Excel **URL:** https://www.compsmag.com/blogs/how-to-remove-a-year-from-a-date-in-microsoft-excel/ **Author:** Ayushi Chauhan **Published:** 2022-04-13 **Updated:** 2022-04-13 **Categories:** Blogs **Tags:** Blogs Daily, guiderobert, Guides and Tutorials, guiding12, How To Guide, How To Guides, Tips, Tricks **Reading Time:** 4 min --- This tip is about the how to Remove a Year from a Date in Microsoft Excel. So read this free guide, How to Remove a Year from a Date in Microsoft Excel step by step. If you have query related to same article you may contact us. ## How to Remove a Year from a Date in Microsoft Excel - Guide Suppose you have a spreadsheet with the birthday information for all employees in the company and you want to remove the year from the birthday information to protect the employee's privacy. How to easily remove year from date? There are some formulas you can use to remove the year from the date, for example, B. Text function, concatenation function, you can apply the formulas. Then tap Enter, select cell C2, and drag the fill handle over the range of cells you want to contain this formula. And the year has been removed from the date, see screenshot. In the Apply Date Formatting dialog, select a date format type that contains only the day and month, such as B. 14.3. or 3.14. and then click OK button button. Suppose you have a list of dates in the range B1:B5 that contain date values. And you only want to show the month and day parts. Then you need to remove the year from the cells. How is it going. You can use formula based on MONTH function and DAY function to get the result. ## Custom number formatting Although a date value in an Excel cell is technically a number, Microsoft Excel uses a specific type of formatting to display it. The same goes for currency values, where currency symbols are added to values ​​to show that they relate to money. When you add a date in Excel in a format it recognizes, Excel automatically changes the cell number format to the “Date” type. You can customize this type to display the date value in different ways. For example, you can switch between “11/02/2021” (in the DD/MM/YYYY format commonly used in the UK) and “2021-02-11” for February 11, 2021. However, you can customize this number format to remove the year entirely from the display. The value itself will not change, but Excel will not show the year value thanks to custom number formatting. To do this, highlight the cells that contain their original date values ​​and select the “Home” on the ribbon bar. From there, select the arrow next to the number format dropdown menu and choose the “More number formats” option. From the “Format Cells” menu, select a formatting style you like from the “Date” options provided. Once selected, choose the “Custom” option. In the “Custom” option, you will see the date number formatting style shown as text in the “Type” box. For example, “11/02/2021” would be displayed as “dd/mm/yyyy” in this box. To remove the year, be sure to remove any references to “yyyy” or “yy” in the “Type” box, as well as any excess delimiters such as a dash or slash. For example, “2/11/2021” would require you to remove “/yyyy” from the “dd/mm/yyyy” type box, leaving “dd/mm” in place. After making your changes, select the "OK" button button. ## Concatenate Function Concatenation is a term that basically means to link or combine two or more pieces of data. In Microsoft Excel terms, concatenation can be used to add multiple strings of text, numbers, or cell values ​​into a new cell. If you want to remove the year from a date in Excel, you can combine the output of two functions (like DAY or MONTH) using CONCATENATE. Instead of hiding the year from the view using custom number formatting, CONCATENATE (with DAY and MONTH) lets you create a separate value that doesn't include the year. To do this, open an Excel workbook containing your date values, or create a new workbook and place the date values ​​in separate cells. To use CONCATENATE with DAY and MONTH, insert a new function using this structure, replacing the cell reference (A2) with a reference to the cell that contains your date: =CONCATENATE(DAY(A2),”/”,MONTH(A2)) The values ​​returned by DAY and MONTH are separated by a special delimiter character, such as a comma or slash, to show that the value returned is a date. Each value (DAY, the delimiter and MONTH) are separated by a comma in the CONCATENATE function. ## Final note I hope you like the guide How to Remove a Year from a Date in Microsoft Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends. --- *End of Article*