How to add date format into if statement?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
=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)
 
--

HTH

RP
(remove nothere from the email address if mailing direct)
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with dates 2
Using multiple IF statements 1
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) 6
IF statement help 1
Which is the best MBOX Converter Tool different formats conversion? 5
IF Function with Dates 9
Countif statement using dates 15
Calculate elapsed time excluding specific timeframe 10

Back
Top