I have a spreadsheet where a whole team enter data, and it's often not in date order (e.g. Mary enters 15th October, then Sally enters 7th October further down etc).
On a separate sheet I would like to automatically list under each month the dates that have been scheduled, but in date order.
Is there a way to summarise this without running a macro or using a pivot table? It needs to be for managers who aren't excel savvy to get a quick overview.
So basically taking Column B of Sheet 2 (which is a list of random dates) and in Sheet 1 showing all the dates out into the correct month section, in correct order.
On a separate sheet I would like to automatically list under each month the dates that have been scheduled, but in date order.
Is there a way to summarise this without running a macro or using a pivot table? It needs to be for managers who aren't excel savvy to get a quick overview.
So basically taking Column B of Sheet 2 (which is a list of random dates) and in Sheet 1 showing all the dates out into the correct month section, in correct order.
Last edited:
