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

Maybe....

=IF(COUNT(O235,R235)=2,DAYS360(O235,R235),"")

Vaya con Dios,
Chuck, CABGx3


"roy.okinawa" wrote in message
...
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?