excel vba training - Dates

Hi Jennifer

Thanks for your question.

I'm not sure you can get the difference between two dates to display as number of years and months - you can get the difference to display as one or other other as far as I know.

A function you might be interested in looking at in relation to your question is the DATEDIF (date difference) function. Here is a link to an article that provides some useful information on this function, including what error messages could come up when you use if and what they mean:

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

thanks
Amanda