ExcelBanter - Formula trouble

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula trouble (https://www.excelbanter.com/excel-discussion-misc-queries/190335-formula-trouble.html)

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

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

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