Show Month from Week #

Luke W.
Luke W. ✭✭✭✭✭

Hello,

I'm creating a helper column that needs to show what month a week number was from.

For Example, I have a sheet with a [Date] column and [Week #] column.

image.png


I have second sheet that has a Week # and is pulling data from my first sheet based on a calculation using Week #.

In the second sheet, I'd like to create a helper column that displays the Month that the Week # is from, I.E. - Week 1 = January, Week 6 = Feb, etc...

Can this be done with a formula?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!