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!


--
Geobass
------------------------------------------------------------------------
Geobass's Profile: http://www.excelforum.com/member.php...o&userid=33458
View this thread: http://www.excelforum.com/showthread...hreadid=532636

Need help with formula
 

I think you want something like this:

=IF(TODAY()-A1730,"OverDue","")

Hope this helps.

Pete


--
Peter81
------------------------------------------------------------------------
Peter81's Profile: http://www.excelforum.com/member.php...o&userid=25353
View this thread: http://www.excelforum.com/showthread...hreadid=532636

Need help with formula
 

Peter81 Wrote:
I think you want something like this:

=IF(TODAY()-A1730,"OverDue","")

Hope this helps.

Pete

That did it! Thanks so much!


--
Geobass
------------------------------------------------------------------------
Geobass's Profile: http://www.excelforum.com/member.php...o&userid=33458
View this thread: http://www.excelforum.com/showthread...hreadid=532636