Excel: count months looking at a list of dates


I need a formula that will tell me the number of month based on the list of dates: e.g.

10/10/2014
10/24/2014
11/7/2014
11/21/2014
12/5/2014
12/19/2014
1/2/2015
1/16/2015
1/30/2015
2/13/2015
2/27/2015
3/13/2015
3/27/2015
4/10/2015
4/24/2015
5/8/2015
5/22/2015
6/5/2015
6/19/2015 I want to know that I have 9 months


This question generated 19 answers. To proceed to the answers, click here.

This thread is current as of April 28, 2015.


For more resources for Microsoft Excel