--

HTH

RP
(remove nothere from the email address if mailing direct)


"Eric" wrote in message
...
Thank Karthik for your reply,

I forget to describe the condition.
I want to determine whether the day and month only are within certain
period?
such as
If "10-Mar-2005" is between "1-Mar" and "14-May" and ignore the year, then
return 1, else return 0.
Reture value should be 1 in this case.
Do you have any idea?
Thank you
Eric


"Karthik" wrote:

Hi Eric,

Maybe you could try putting the date in a separate cell and giving a
cell
reference to this one in the IF function. Hope this works!

Regards,
Karthik

"Eric" wrote:

Does anyone know how to add date format into if statement? such as
If(A1="1-Mar-2005", 1,0)
Thank you
Eric