Table of Contents
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
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.