Help

Making a date from a week and year number

Topic Labels: Formulas
Solved
Jump to Solution
753 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Vito_Kloots
4 - Data Explorer
4 - Data Explorer

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

Screenshot 2022-09-01 at 11.38.54

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

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")

See Solution in Thread

1 Reply 1
Mohamed_Swella1
13 - Mars
13 - Mars

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")