Return Blank Cells Instead of Zeros

[grobbit]

Hi.

=DATEDIF(A2,B2,"D") is returning the number of days that have passed between two dates
e.g.

A2=01/01/2021
B2=07/01/2021
= 6 days



If B2 is empty, a "-" (hyphen) is returned, e.g.

=IFERROR(DATEDIF(A2,B2,"D"),"-")


But empty cells in both column A and column B that have not yet had any dates entered are returning a zero e.g. '0'

I would like these cells to return a blank until at least a date in column A is entered?


Thank you.

[Fluff13]

How about
=IF(SUM(A2:B2)=0,"",IFERROR(DATEDIF(A2,B2,"D"),"-"))

[grobbit]

Many thanks

[Fluff13]

You're welcome & thanks for the feedback.