Help

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

243 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Cam_Sinclair
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1
Kutluhan_Aykut
4 - Data Explorer
4 - Data Explorer

I have the same issue and havent figured out yet.
Dont know if it is posibble or not…