Need help with formula

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!

I think you want something like this:

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

Hope this helps.

Pete

Originally Posted by Peter81

I think you want something like this:

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

Hope this helps.

Pete

That did it! Thanks so much!