Get a date from a week number

Hello everyone

Do you know if it is possible to get a date from a week number information ?

Here is the exemple :

I have data structured in this format : 2020-13 (Year-Weeknumber)

I would like to convert this data into a date, for exemple firstdayoftheweek/month/year.

Do you know if I can set up a formula like this ?

Thank you

Corentin

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!