Week number in Quick Sight

[Prachi]

How can we get week number in Quick Sight?
Example is as below :

Week	Week no
May 15th, 2022	20
May 8th, 2022	19

[JoseB-aws]

Hello,
This is a great post explaining how to do it:

Week Numbers (1-53)

Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic to account for that). FYI this uses weeks starting Sun. dateDiff(truncDate("WK", truncDate('YYYY', {order_date})), {order_date}, 'WK')+1

[Norbert]

I would need exaclty the opposite. Could you please help?

I have week numbers in the tables, but exact date would be more preferable to have