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?
