Hello, how do I write a formula to compare two dates in two different Excel cells and then choose the latest date to then add 26 weeks to that date and therefore calculate a new date in another cell?
Hey you can do it with Max function, using max function you get latest date then add 182 to it to get your desired date. For better understanding I attached worksheet.