MeganLanpolsaen
New Member
- Joined
- Nov 15, 2019
- Messages
- 3
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>
<colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody>
</tbody>
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>
Thank you in advance for your help!
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
| A | B | |
| 1 | 10/24/19 | =A1+10 |
| 2 | 10 |
<colgroup><col style="width: 142px"><col width="142"><col width="142"></colgroup><tbody>
</tbody>
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>
