Forum Discussion
Sorting and Formatting Dates Formula
Hi! I am pulling data from one sheet (Current Employees) in a workbook to a new sheet (Anniversaries). I want to sort a column of dates by month and day. The original data is in a m/d/yyyy format (ex...
Not sure what the resistance to adding columns is, but if you will recall, dates in Excel are actually serial numbers. So the sorting isn't actually done by year, month and day anyway. It's done by serial number. If you want to ignore the year, you're going to have to extract month and day from the serial number into "helper columns" and then do the sorting.
That works, but when I inserted a column, it changed the formatting for another column. It is a date in the original sheet (and it's being used for calculations in another column), but now, on the sheets where I am extracting the array, it shows the serial numbers. Is there a way to lock the formatting for that column so the dates show as dates on the other sheets?