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

[Guest]

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

 

[Jason Morin]

Try this:

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

HTH
Jason
Atlanta, GA

 

[CLR]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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 G9>Today(), you want the result "Pass".
What if G9=Today()?

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