Excel - Determine the number of years from a date

December 2016



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

Related :

This document entitled « Excel - Determine the number of years from a date » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.