# First day of Month day name in Current year equal to Day Name of previous Year

Hi All,

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"

Thank you!

Amritha..

capture.jpg (70.4 kB)
10|10000 characters needed characters exceeded
• Dear Coudld you elaborate...

you written..

CY_Date, DayName, PY_Date, Day_Name

05/01/2020,Friday,05/03/2020,Friday

or

05/01/2020,Friday,05/03/2019,Friday.

(actual)05/01/2020 is sunday. you written friday.

05/03/2019 is tuesday you written friday.