Hia

I want to use a formula which will return a 0, if the date is on or prior to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks

Assuming your date is in A1, try this:

=IF(A1<DATE(2005,1,1),0,2)

Hope this helps.

Pete

On Oct 29, 12:44*pm, Stonsey
wrote:
Hia

I want to use a formula which will return a 0, if the date is on or prior to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks

=IF(A2<=DATEVALUE("12/31/2004"),0,IF(A2=DATEVALUE("1/1/2005",2,"No criteria
match"))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Stonsey" wrote:

Hia

I want to use a formula which will return a 0, if the date is on or prior to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks

dates being in A2, A3, ...
=--(A2=DATE(2005,1,1))
Regards,
Stefi

€žStonsey€� ezt Ã*rta:

Hia

I want to use a formula which will return a 0, if the date is on or prior to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks

Hi,

=IF(D8<=DATE(2004,12,31),0,2)

hope this helps

"Stonsey" wrote:

Hia

I want to use a formula which will return a 0, if the date is on or prior to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks

I think Stefi may have intended to say
=(A2=DATE(2005,1,1))*2
--
David Biddulph

"Stefi" wrote in message
...
dates being in A2, A3, ...
=--(A2=DATE(2005,1,1))
Regards,
Stefi

"Stonsey" ezt írta:

Hia

I want to use a formula which will return a 0, if the date is on or prior
to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks

It was an oversight, I didn't notice that the OP wants 2 on the TRUE branch.

Sorry for the late answer but I've just now realized that my e-mail
notification doesn't work.


--
Regards!
Stefi



€žDavid Biddulph€� ezt Ã*rta:

I think Stefi may have intended to say
=(A2=DATE(2005,1,1))*2
--
David Biddulph

"Stefi" wrote in message
...
dates being in A2, A3, ...
=--(A2=DATE(2005,1,1))
Regards,
Stefi

"Stonsey" ezt Ã*rta:

Hia

I want to use a formula which will return a 0, if the date is on or prior
to
31 Dec 2004 and a 2 if date entered is on or after 1 January 2005 - Would
love some help on how to do this

Thanks


.