Two date columns - need to take the earlier date of the two and add 10 years


I am hoping for some assistance with nailing down this formula so that it displays 10-years on top of the earlier date from two columns. I found a prior community post with the below formula, but I just can't seem to get it to work the way I want it to.

=IF(AND(ISDATE([Last AF]@row), ISDATE([Last BIR]@row)), MIN([Last AF]@row, [Last BIR]@row) + 3650))

Reference Post:

*Last AF and Last BIR can either both contain dates, or one may be empty.

**If both columns do not contain dates, can the formula column state "No Data".

Any help is appreciated.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!