There are a couple of ways you can remove the year from a date shown in Microsoft Excel. You can use custom cell formatting to hide it or use various functions like CONCATENATE to remove it completely. Here’s how.
Read This Article on How-To Geek ›
Source : How to Remove a Year from a Date in Microsoft Excel
