Thread: Getting system date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
goober[_7_] goober[_7_] is offline
external usenet poster
  
Posts: 1
Default Getting system date

=IF(AND(A12,B15,((TODAY()-C1)/365)3),"GOOD",IF(AND(A12,B15,((TODAY()-C1)/365)<3),"BAD","Unknown"))

This should work for you. Aren't formulas fun.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=479422

Reply With QuoteReply With Quote