Add 6 months and end of month

Good morning,

I am trying to identify how to add 6 months to a column [Approved Date] but add 6 months and the last weekday of the month.

So if given 7/23/2024, the next review date would be 01/31/2025. Or in May 2025, it would return 5/30/2025. I tried a few formulas but just can't get it to work.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!