Expired Due Date

[dragonmouse]

I am drawing a blank...I want to take TODAY() date and compare it to a DUE Date and see if it is over due or not. I know this formula is probably simple.

Example todays date is 10 May 2018:

Book "A" is due 30 May 2018 = FALSE
Book "B" is due 03 MAY 2018 = TRUE
Book "C" is due 28 FEB 2017 = TRUE
Book "D" is due 05 Jun 2018 = FALSE

I tried "=TODAY()>A5" but it didn't work. I'm sure it's simple just not that simple.

 

[JoeMo]

Try:

=TODAY()-A5>0

 

[dragonmouse]

PERFECT...GOSH I was sooooooo close. It really was almost that simple. Thank you.