Hi,
I am trying to add a year to a date and end it on Sunday ie
Start date is 5th April 2021, I would like to add a year to this and have tried =EDATE(E6,12) and =DATE(YEAR(E6) + 1, MONTH(E6), DAY(E6)) but it returns 04/04/2021, which is a Monday, the calculation is doing what it needs to but other than adding a -1, is there a clever way of ending the date on the Sunday year on?
I am trying to add a year to a date and end it on Sunday ie
Start date is 5th April 2021, I would like to add a year to this and have tried =EDATE(E6,12) and =DATE(YEAR(E6) + 1, MONTH(E6), DAY(E6)) but it returns 04/04/2021, which is a Monday, the calculation is doing what it needs to but other than adding a -1, is there a clever way of ending the date on the Sunday year on?