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?