Skip to main content

Hi,

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

Reply


Terms & Conditions