View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve
 
Posts: n/a
Default Negative return in =DATEDIF function

Is it possible to display the result of a negative DATEDIF function? I
am checking a column of warranty expiration dates against the current
date, and displaying that in an adjacent column. When the item is past
its expiration it shows the #NUM! error. How would I format this to
show the number of days past its expiration?