Hi All,
Could someone please help me in the logic for the below example:
I have 4 columns.
CY_Date, DayName, PY_Date, Day_Name
05/01/2020,Friday,05/03/2020,Friday
All the daynames for CY and PY should be same. First day of current year day name should match previous year dayname irrespective of the date.
I tried
RelativeDate(ToDate([Previous Year RO Close date];"M/d/yyyy");1)
It worked for February and January. However, It is breaking for March. So, Every month its different. One month it is adding 1 day, other month 2 days. So , Could you help me in writing this logic where the "day name of first day of current year matches the first dayname of previous year"
Your help is greatly appreciated.

Thank you!
Amritha..