Excel - Calculation between time interval

April 2017



Issue


I want to retrieve sales within 24 months.

For example:

I have:
    • 22/09/2009 in cell A1 and 25/08/2011 in C1
    • 22/09/2009 in A2 and 25/10/2011 in C2

I wish to emphasize on the sales performed during the latest 24 months.

Solution


Use this formula:
=(YEAR(H4)-YEAR(D4))*12+MONTH(H4)-MONTH(D4) 

Related


Published by aakai1056. Latest update on October 25, 2011 at 09:31 AM by aakai1056.
This document, titled "Excel - Calculation between time interval," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).