Hi,

Assume I have a base-string 'May-2014' and few other related strings in a target array i.e. 'Jul-2014', 'Nov-2014', 'Dec-2014'. Now I want to calculate the number of months between base-string and target-array. Therefore I want to get an array of integer like 2, 6, 7

Is there any VBA function available to achieve that?

Thanks for your pointer.