ExcelBanter - formate date by month & day & ignore year

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formate date by month & day & ignore year (https://www.excelbanter.com/excel-programming/374969-formate-date-month-day-ignore-year.html)

Frank

formate date by month & day & ignore year

I need to format cell for month & day only. No Problem But when I sort excell
uses year also and I don't want that

All times are GMT +1. The time now is 12:20 AM.