Find last years date (ISO Standard)

Hi,

I have a calendar table with these columns:
DATE | DAYNAME | DAYINWEEK|ISO WEEKNUM

I would like to find last year's data on each DATE row but have not found a way to do it using the ISO standard.

Wanted result:

Datasets

Date Time

Accepted answers

Hope this helps : )

Please find the updated workflow I was displaying month name instead of weekday name. Thanks @binu_acs for pointing it out 🙂

Workflow:

Hope this helps : )

Can you provide this in an excel file

How is "2020-12-21" last year date "2019-12-23" ? Am I missing something

Hi,

Here it is!

@ulysses_no Very similar to @atcodedog05 approach

Hi @ulysses_no

Please find the updated workflow I was displaying month name instead of weekday name. Thanks @binu_acs for pointing it out 🙂

Workflow:

Hope this helps : )

@atcodedog05 and @binu_acs thank you for your time and solution, both worked excellently!