Forum Discussion
Find next meeting date for a specific meeting subject
Hi, I'm trying to build a spreadsheet to pull together which will include flagging the next meeting date for a specific meetings.
I've exported my calendar from outlook to an excel sheet 'calendar' which contains dates for multiple reoccurring meetings exported from Outlook, for example (UK date format):
meeting 1 | 01/04/2024 |
meeting 1 | 01/05/2024 |
meeting 1 | 01/06/2024 |
meeting 2 | 01/04/2024 |
meeting 2 | 01/05/2024 |
meeting 2 | 01/06/2024 |
meeting 3 | 01/04/2024 |
meeting 3 | 01/05/2024 |
meeting 3 | 01/06/2024 |
I want to have a cell in a separate sheet which will look at the next upcoming date for a specified meeting subject, how can I achieve this please?
And as a progression would there be any way to look this up directly in my Outlook calendar which would save me regularly exporting my calendar to the sheet in Excel?
Any help would be appreciated, thanks
Hi, can you try if this is what you want? You can do it with XLOOKUP() and the FILTER() function. I don't know how to do this directly in Outlook.