Xth weekday of next month formula


I am trying to write a formula that will return a date that is the Xth weekday of the month following a date entry.

For example. I have 4/21/23 as my date entry. In a separate cell I want it to show the date for the second Monday of the month of May (5/8/23).

I found this formula but it is based off the current month of the Date I have already:

=IF(WEEKDAY(DATE(YEAR(DateColumn1), MONTH(DateColumn1), 1)) <= 6, 10, 17) + (DateColumn1 - DAY(DateColumn1)) - WEEKDAY(DATE(YEAR(DateColumn1), MONTH(DateColumn1), 1))

Any ideas on how I can adjust my formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!