Skip to main content

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

  • May 1, 2018
  • 1 reply
  • 13 views
C

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

    K

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

    Terms & ConditionsAccessibility statement