Finding the date for a Weekday in the nth week of a month


#1

Hi everyone,

We have regular monthly tasks which occur on the nth weekday of the nth week each month. Eg: the 3rd Wednesday of each month.

I’m trying to create a formula which gives the date of the nth Weekday of the month. For example: the THIRD Wednesday in May 2018 will be May the 16th. So the 2 inputs are {Weekday} {Week of Month} and the output is a date in the current month.

This way we can map out the recurring tasks on a calendar each month.

Any ideas how that formula would look?