=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo.
 

Why does this not work in telling me the staus of a date?

Try this:

=IF(TODAY()G9,"Overdue","Pass")

HTH
Jason
Atlanta, GA

-----Original Message-----
Why does this not work in telling me the staus of a date?
.

Or this..........

=IF(AND(TODAY()G9,H9<"PAID"),"Overdue","Pass")

Vaya con Dios,
Chuck, CABGx3



"Fkor" wrote in message
...
Why does this not work in telling me the staus of a date?

It does not work, because your argument is flawed. Is this what you want to
achieve?

If G9<Today(), you want the result "Overdue"
If G9Today(), you want the result "Pass".
What if G9=Today()?

=IF(G9<TODAY(),"Overdue",IF(G9TODAY(),"Pass","")) will work better.

"Fkor" wrote:

Why does this not work in telling me the staus of a date?