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'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
That did it! Thanks so much!Originally Posted by Peter81
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks