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?
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. Thank you Eric |
#3
|
|||
|
|||
How to add date format into if statement?
One way:
=IF(A1=DATE(2005,3,1),1,0) or, more efficiently =--(A1=DATE(2005,3,1) since XL treats boolean operators (TRUE/FALSE) as 1/0 in math operations (negation, then negation again). In article , "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?
See response in worksheet.functions
-- 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?
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) |