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?
|