[Becky]

I am trying to use the =days360 function.
=days360(D15,D19)
THIS WORKS FINE EXCEPT IF THERE IS NO DATE IN CELL D15, IT GIVES ME -39983.
How can I get it to enter a "0" if there is no date in one of the cells or
enter a default date??

[Jim Thomlinson]

=if(or(d15="", d19=""), 0, days360(D15,D19))
--
HTH...

Jim Thomlinson


"Becky" wrote:

I am trying to use the =days360 function.
=days360(D15,D19)
THIS WORKS FINE EXCEPT IF THERE IS NO DATE IN CELL D15, IT GIVES ME -39983.
How can I get it to enter a "0" if there is no date in one of the cells or
enter a default date??

[Peo Sjoblom]

=IF(COUNT(D15,D19)=2,DAYS360(D15,D19),0)


btw, do you really need DAYS360?

If you want to count the days you can just use

=D19-D15

format result as general

also you wouldn't get a negative value if D15 is empty, you would
get it if D19 is empty


=IF(COUNT(D15,D19)=2,D19-D15,0)

--


Regards,


Peo Sjoblom





"Becky" wrote in message
...
I am trying to use the =days360 function.
=days360(D15,D19)
THIS WORKS FINE EXCEPT IF THERE IS NO DATE IN CELL D15, IT GIVES
ME -39983.
How can I get it to enter a "0" if there is no date in one of the cells or
enter a default date??