My validation button contains month & year ( apr-07,may-07....mar-08). If i
select a particular month in the validation button (eg: Aug-07). I should get
the total no.of months starting from apr-07 to aug-07 i.e., 5 months. Hence i
require a formula to get the total no of months as explained above.


With the help of your fomula i'll extract the data from another sheet.