Thread: If functions and dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Special-K Special-K is offline
external usenet poster
  
Posts: 1
Default If functions and dates

Try this

=IF(A1<NOW(),"OVERDUE",IF(A1<NOW()+90,"LESS 3
MTHS",IF(A1<NOW()+180,"LESS 6 MTHS","MORE 6 MTHS")))

Comparing a date entered in column A with the date/time now and results
in column B

Regards
Special-K


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562469

Reply With QuoteReply With Quote