sorting data by date
I need help sorting some dates into month order. The information has been
exported from another system into an Excel spreadsheet. At present the data is in dd/mm/yy format. I want to sort the information by month. The data sort function will only sort it by day at present. How can I change the format so that I can sort by month? |
Insert a new column adjacent to your dates. In the new column use the formula
=month(cell with date) Copy the formula down for all the dates, then sort on the new column. That will put all the January dates together, regardless of the year, then the February dates, regardless of the year, etc. "Katherine" wrote: I need help sorting some dates into month order. The information has been exported from another system into an Excel spreadsheet. At present the data is in dd/mm/yy format. I want to sort the information by month. The data sort function will only sort it by day at present. How can I change the format so that I can sort by month? |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com