Recurring meeting on Last Thursday of the Month (etc...)

Hi @SY444 - thanks for sharing, cool that the formula was right there on GCs site :slight_smile:
This should do the trick for you:

TEXT(DATE(YEAR(TODAY()), MONTH(EDATE(TODAY(),1)), 7) - WEEKDAY(DATE(YEAR(TODAY()), MONTH(EDATE(TODAY(),1)), 7), 3), “YYYY-MM-DD”)

Thanks for the assist @rob
Mark

2 Likes