Days between dates, blank if one or both columns have no date

I'm attempting to write a formula that will allow me to determine the number of days between two dates but to leave the cell with a zero in it if either of the first two date cells are blank or have N/A in them. Here's what I have so far:

=IF(AND(K5="N/A",L5="N/A"),0,L5-K5)

This will give me a zero in the cell if both date cells are blank or will give me the days between if not. How do I get it to also put a zero in the cell if only one of the date cells is blank?

Any help or information is greatly appreciated. Thanks.

Use OR() instead of AND(). That will deliver a TRUE if any of the nested conditions are TRUE; the AND function will only deliver TRUE if all the nested conditions are TRUE.

Originally Posted by ben_hensel

Use OR() instead of AND(). That will deliver a TRUE if any of the nested conditions are TRUE; the AND function will only deliver TRUE if all the nested conditions are TRUE.

Greatly appreciated, thanks. Works like a charm.