Average number of months

[shan88]

I have a column (Excel 2003) that contains several dates in mm/dd/yyyy format
and I would like to be able to obtain the average number of MONTHS in the
group of dates.

I could, if it made it easier, add seperate columns for - month - day - year
- and then if a formula could figure out the AVERAGE number of months in the
month column that would also do for me.

 

[Pete_UK]

Chip Pearson shows how to use the DATEDIF function here:

http://www.cpearson.com/excel/datedif.aspx

It can tell you the number of years, months or days between two dates,
and you can put these in three different columns if you wish. In
working out the average number of months, you will have to take
account of the years (multiplied by 12).

Hope this helps.

Pete