Forum Discussion
Date calculation
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
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
TammySK Something like this?
- Thank you!!!
