| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
How to add date format into if statement?
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 |
|
#3
|
|||
|
|||
|
How to add date format into if statement?
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 |
|
#4
|
|||
|
|||
|
How to add date format into if statement?
=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" wrote in message ... Does anyone know how to add date format into if statement? such as If(A1="1-Mar-2005", 1,0) Thank you Eric |
|
#5
|
|||
|
|||
|
How to add date format into if statement?
-- 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 |
|
#6
|
|||
|
|||
|
How to add date format into if statement?
=IF(AND(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))=DAT EVALUE("01-Mar-"&YEAR(TODA Y())),DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))<=DATEV ALUE("14-May"&YEAR(TODAY() ))),1,0) -- 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 |
|
#7
|
|||
|
|||
|
How to add date format into if statement?
Thank everyone very much
Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Does Date Format Change on Chart | Excel Discussion (Misc queries) | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| Date Format Inside of a SUMIF Statement | Excel Worksheet Functions | |||
| How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Linear Mode
