0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Calculation between time interval

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) 
0
Thanks

A few words of thanks would be greatly appreciated.

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