CAN YOU HELP WITH A FORMULA?
 

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO")))
last if you can igno
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO"))

pls do rate

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

Nearly there but not quite... OKs are showing fine, but the "DOs" are coming
out with the #NAME? error. Any ideas?

Thanks & regards,
--
MARY


"Muhammed Rafeek M" wrote:

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO")))
last if you can igno
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO"))

pls do rate

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

Ooooooooops Sorry. i forgot to put =

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO")))
last if you can igno
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO","DO"))


"Mary Mace" wrote:

Nearly there but not quite... OKs are showing fine, but the "DOs" are coming
out with the #NAME? error. Any ideas?

Thanks & regards,
--
MARY


"Muhammed Rafeek M" wrote:

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO")))
last if you can igno
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO"))

pls do rate

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

Try this ...
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO")))

Please rate me.

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

Sorry if this comes up twice... I thought I had posted a message, but it
does not appear to be showing. Thanks for your help - I am half way there,
but am still getting an error message. The "OKs" are coming out alright, but
the "DOs" are coming up with a #NAME? error. Any ideas how to resolsve this?

Thanks & regards,
--
MARY


"Muhammed Rafeek M" wrote:

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO")))
last if you can igno
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO"))

pls do rate

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

or more simply....
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO"))

Rob

"Naveen" wrote in message
...
Try this ...
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO")))

Please rate me.

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be
done.
Have used the "If" function and embedded the "TODAY" formula within that.
I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether
or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY

CAN YOU HELP WITH A FORMULA?
 

Brilliant! Sorted! Thanks for your help.....
--
MARY


"Naveen" wrote:

Try this ...
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO")))

Please rate me.

"Mary Mace" wrote:

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?
--
MARY