Need Help Building a Formula

Copper Contributor

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.

3 Replies

@Byron_Foster 

Perhaps

=MAX( EDATE(termDate,12),EDATE(hireDate,36))

@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".

@Byron_Foster 

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)