Please help!! Need help with specialized formula.

[MeganLanpolsaen]

Hi everyone,

Thank you in advance for your help!

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]10/24/19[/TD]
[TD="align: center"]=A1+10[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=b7e1cd]#b7e1cd[/URL] , align: center"][/TD]
[TD="align: center"]10[/TD]
[/TR]
</tbody>[/TABLE]


I am trying to write a formula that will hide B2 if A2 is blank, but show the correct date in B2 if A2 is not blank. How do I do this?
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

 

[Eric W]

Welcome to the forum!

In B2:

=IF(A2="","",A1+10)

 

[MeganLanpolsaen]

Thank you Eric!

 

[Eric W]

Happy to help!