View Single Post
  #2   Report Post  
Alex Delamain
 
Posts: n/a
Default


This should do it

=IF(C2-B2<=0,"",IF(C2-B2=1,"1 day",+C2-B2&" Days"))


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=274111