How to show a blank cell if data isn't entered in a specific cell

Hi all,

I am trying to work out how to keep a cell blank until another piece of data is entered.

I want my output in Cell M5 for example.

I have the forumla to work out what I need however the cell K5 will be updated once it's been sent.

=IF($H5="Claim",EDATE(K5,3),"")

At the moment cell M5 is returning a date of 31/03/00 as no data is entered in K5 but I would like to keep this blank until a date is present in cell K5.

Any help would be most helpful.

Thanks

Or try:

=IF(AND($H5="Claim",K5>0),EDATE(K5,3),"")

Hi Ali,

Thanks for the welcome and swift response. I tried that and it's stating you've entered too many arguments for this function.

Trying to see what the issue is with it.

Thanks

Phuocam, amazing thank you that has worked perfectly Thank you once again.

Originally Posted by AliGW

You must have missed something:

=IF(K5="","",IF($H5="Claim",EDATE(K5,3),""))

Thank you Ali, just tried that I forgot to put my forumla as IF again, tried this and it also works a treat. Thanks for the both options. You have made my day