Date calculation

New Contributor
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?
4 Replies

@TammySK Something like this?

Screenshot 2021-02-04 at 18.25.44.png

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.

Thank you!!!
Thank you