How to use the IsBlank Function with the DAYS function - Excel 365

Occasional Visitor



I am just running a simple spreadsheet for collating my energy usage - see really simple!



But I just cannot get rid of the 0s and the date reference when one of the dates is blank, re attached excerpts...



I am trying to use this forumula, but it's not working; so can anyone help me please?






Thank you.

2 Replies

@MaggieMoonlight There is a superfluous parenthesis.





If A18 and/or A19 contain formulas, it's better to use