Making a date from a week and year number

[Vito_Kloots]

Hello! Does anyone know how you can transform a week number and a year number to a date?

[Mohamed_Swella1 · Accepted solution]

Hi @Vito_Kloots ,

Welcome to Airtable Community!

You can use this formula to get the date you need

DATEADD(DATETIME_PARSE("1/1/"&{Year Field}),{Week Field},"weeks")