Problems iwth IF/AND-please help me correct!

[freckledgenes]

I have a table such as this one. I have set up the formula =IF(B2="Yes",A2+182,"NA"),and so one, for the further cells.

This is successfully giving me what I need, which is to take the cells in column B in which I have been provided a "Yes" for recontact, look back at the date of initial contact in column A, and then add 6 months (182 days) to that to provide me the date of recontact in column C.

However, I have one authorized recontact in which I do not know what the initial date of contact is-how do I edit the above formula so that it gives me an "NA" for that cell (C6 as shown below) as well?

Thanks!

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]First Invite[/TD]
[TD]Recontact Allowed?[/TD]
[TD]Date for Recontact[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]12/8/2016[/TD]
[TD]Yes[/TD]
[TD]6/8/2017[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7/7/2017[/TD]
[TD]Yes[/TD]
[TD]1/5/2018[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7/11/2017[/TD]
[TD][/TD]
[TD]NA[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]8/23/2017[/TD]
[TD]No[/TD]
[TD]NA[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Unknown[/TD]
[TD]Yes[/TD]
[TD]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Welcome to the board.

Try:

=IFERROR(IF(B2="Yes",A2+182,"NA"),"NA")