Forum Discussion

Byron_Foster's avatar
Byron_Foster
Copper Contributor
May 27, 2020

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

excel
Formulas and Functions

3 Replies

    • Byron_Foster's avatar
      Byron_Foster
      Copper Contributor
      May 27, 2020

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

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 28, 2020

        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)