thanks for u r prompt reply bob
but i'm not able to understand how i have to take my values as per u r
formula. plz provide u r help. i'll explain clearly what is my requirement.
when i select the month in the validation, i need to count the no of months
from "apr-2007" i.e., financial year ( apr - mar ). when i select the month (
ex: Jul -2007) in the validation, it has to count the no of months starting
from "Apr-07" in the required cell.
validation button conatins apr2007 - mar2008 (12 months)
i hope u have clearly understand my thing.
Thanks in advance.

"Bob Phillips" wrote:

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.