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 ...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 27, 2020

Byron_Foster 

Perhaps

=MAX( EDATE(termDate,12),EDATE(hireDate,36))
  • 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)