Need help with formula

G

Geobass

I'm trying to create a formula to calculate if dates in a column are
older than 2 years from today. If so it will say "overdue". Maybe I'm
formatting it wrong, but I can't seem to get it to work. Any ideas?

Thanks!
 
P

Peter81

I think you want something like this:

=IF(TODAY()-A1>730,"OverDue","")

Hope this helps.

Pete
 
Top