How to add date format into if statement?

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

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

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

--

HTH

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


"Eric" <Eric@discussions.microsoft.com> wrote in message
news:245A8CCB-6A6E-4CA7-8E3D-E5DF970E696A@microsoft.com...
> 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

=IF(AND(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))>=DATEVALUE("01-Mar-"&YEAR(TODA
Y())),DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<=DATEVALUE("14-May"&YEAR(TODAY()
))),1,0)


--

HTH

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


"Eric" <Eric@discussions.microsoft.com> wrote in message
news:245A8CCB-6A6E-4CA7-8E3D-E5DF970E696A@microsoft.com...
> 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

=IF(A1=--"2005-03-01,1,0)

or

=IF(A1=DATE(2005,03,01),1,0)

or

=IF(A1=DATEVALUE("1-Mar-2005"),1,0)

--

HTH

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


"Eric" <Eric@discussions.microsoft.com> wrote in message
news:7E636512-C2AE-4CA0-A661-5A6A77B1164D@microsoft.com...
> Does anyone know how to add date format into if statement? such as
> If(A1="1-Mar-2005", 1,0)
> Thank you
> Eric

Thank everyone very much
Eric