Use the below formula in any other cell: –
=DATEDIF(A1, TODAY(), “Y”)This formula is a secret formula so it won’t appear in the in-built formula list.
=TODAY() helps in dynamic update everyday.
Use can use “M” to calculate months and “D” to calculate days also!Better, isn’t it?!