Date Formula: how to get a Monday Date based on Week number

In column A, I listed all weeks number (from 1 to 52)
in column B, I would like to have the correspondant date based on Monday.

ex in 2021
Column WEEK: 52
Column Day = Monday 27th dec.

How to set up this in airtable?
thank you

Hi @Michael_Leidensdorf ,

You can use the following function:

DATETIME_PARSE({number_of_week },'W')

using the capital , the function datetime_parse returns the corespondent date of on Monday as it follows the ISO specifier

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.