year and weekofyear to MMM-dd-YYYY format

[sqlpuzzle]

Hi,

I have a data set that has  year and weekof year in it. I need to derive two fields,

week begin date (MMM-dd-YYYY) format

week end date (MMM-dd-YYYY) format.

Is this possible?

I am attaching my sample

[ThePeterK · Accepted solution]

Does this get you what you need?:

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))