May 27 2020 12:22 PM
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 year or Column F(hire date) + 3 years
Ex: Term date(10/01/2011) + 1 year = 10/01/2012, Hire Date(01/05/2008) + 3 years = 01/05/2011, so Destroy Date would populate date 10/01/2012 because it is later.
May 27 2020 12:27 PM
May 27 2020 01:59 PM
@Sergei Baklan 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".
May 28 2020 07:21 AM
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)