which is what I believe that my formula does.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"deepak bsg" wrote in message
...
Myne's is in date format only in the validation and i'm not able toa
understand u r formula. My requirement is count the months (starting from
"apr-07")

Thanks in advance

"Bob Phillips" wrote:

Is it text such as Apr-07, or is it a real date? and when you say
validation
button, are you referring to a cell containing Data Validation.

Assuming real dates and DV, something like

=DATEDIF(E4,TODAY(),"M")+1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"deepak bsg" wrote in message
...
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.