Do not show negative numbers

[roy.okinawa]

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?

[CLR]

Maybe....

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

Vaya con Dios,
Chuck, CABGx3


"roy.okinawa" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>
>
>

[roy.okinawa]

That did it.

Thanks.

"CLR" wrote:

> Maybe....
>
> =IF(COUNT(O235,R235)=2,DAYS360(O235,R235),"")
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "roy.okinawa" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
> >
> >
>
>
>