Forum Discussion

aholl165's avatar
aholl165
Copper Contributor
May 02, 2024

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 101/04/2024
meeting 101/05/2024
meeting 101/06/2024
meeting 201/04/2024
meeting 201/05/2024
meeting 201/06/2024
meeting 301/04/2024
meeting 301/05/2024
meeting 301/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

Resources