Hi all,

I am looking to populate a cell with a value based upon the number of different months in a column of data containing dates.

Example:

6-Sep-12
14-Sep-12
25-Sep-12
3-Oct-12
19-Oct-12
6-Nov-12
8-Nov-12
26-Nov-12

The above list contains various dates representing three different months. Therefore the answer to the formula I require based on that range of data would be 3.

Many thanks