Find next meeting date for a specific meeting subject

[aholl165]

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

[#2 · Accepted solution]

@aholl165 

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.

[#3]

@dscheikey this works great, thank you!