Excel - Date format to get term for Expiration date

April 2018


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.
Published by aakai1056. Latest update on February 16, 2010 at 02:19 AM by aakai1056.
This document, titled "Excel - Date format to get term for Expiration date," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Delete rows with same value
Excel - Copy rows to total page