Forum Discussion
Need Help Building a Formula
I would like to build a formula in excel with the following rules: 1. Destroy Date in Column I would populate a date automatically based on whichever is latest date: -Column D(term date) + 1 ...
SergeiBaklan that helped me build the below:
=IF(A2+365>B2+(3*365),A2+365,B2+(3*365))
B2 would be the hire date column
A2 would be the term date column
Then just drag the created column(I used C) down to populate all other dates on spreadsheet.
Thank you for taking the time to assist.
Funny story: My fortune cookie today stated "You will soon receive help from an unexpected source".
I see, thank you for the feedback. In such cases I prefer MAX since it's shorter and formula is more readable
=MAX(A3+365,B3+3*365)