Excel - Calculation between time interval


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.


Use this formula:

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).