month ()

i am trying to get the month from pulling the year and week. I have looked at a lot of post and it says the same formula. I have added it and it worked good for month 1 but get an "invalid value" for month 2 and on.

can you let me know what i am doing wrong.

=MONTH(DATE(Year@row, 1, Week@row * 7 - 2) - WEEKDAY(DATE(Year@row, 1, 3)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!