Excel - Date format to get term for Expiration date

October 2016


I have Purchase date and expiration date in a format of yyyy/mm/dd. I want to get the term of how long will it take from purchase date to expiration.

Example: Purchase date 2010/01/01
Expiration date 2011/01/01

The term of that warrant would be 1year.


I have been supposed that you put the purchase date in A2 and the expiration date in B2:

The formula will be :


and after personalize the cell format as : # ##0\[$year(s)-1]


Thanks to aquarelle for this tip on the forum.

Related :

This document entitled « Excel - Date format to get term for Expiration 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.