Does anyone know how to add date format into if statement? such as
If(A1="1-Mar-2005", 1,0)
Thank you
Eric
Does anyone know how to add date format into if statement? such as
If(A1="1-Mar-2005", 1,0)
Thank you
Eric
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
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 <[email protected]>,
"Eric" <[email protected]> wrote:
> Does anyone know how to add date format into if statement? such as
> If(A1="1-Mar-2005", 1,0)
> Thank you
> Eric
See response in worksheet.functions
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Eric" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks