Blank Cell If Value Is Zero

[detritez]

Afternoon all

I am looking for some help making the formula i am using appear blank if there is not yet values entered in the cells

i am using =DATEDIF(A1,B1,"m")

i am trying to find the difference between 2 dates in months but if the values have not been entered into the cells then it populates as zero? is there a way i can leave it blank

Thanks heaps for your help

Terri

[Trebor76]

Hi Terri,

Assuming the dates are in cells A1 & B1, use the following formula in your destination cell:

=IF(OR(A1="",B1=""),"",DATEDIF(A1,B1,"m"))

Kind regards,

Robert
: D

[detritez]

thanks so much your a life saver : D

[royUK]

You can also hide zeros from the Tools > Options > View menu

[ByTheCringe2]

You can also hide zeros from the Tools > Options > View menu

If you do this, it is important to realise that the cell content will still be 0, not blank, so any tests for cell contents must still be for 0 - can be a bit confusing.