Excel - Determine the number of years from a date

Ask a question


Issue


I want to know how many years have passed, based on a date entered in cell H9. What formula can be used?

Solution


=DATEDIF(H9;TODAY();"Y") 

Excel - Comparing multiple columns
Excel - Display of metric measurements in a cell