View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roy.okinawa
 
Posts: n/a
Default Do not show negative numbers

I have this formula in cell S: =DAYS360(O235,R235).

When O has a date and R does not it is giving me -38138. I do not want a
negative number to appear, as this throws off the average days formula I have
elsewhere. It may be a couple days before a date is added to R.

What do I need to do?