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!

	A	B	C
1	First Invite	Recontact Allowed?	Date for Recontact
2	12/8/2016	Yes	6/8/2017
3	7/7/2017	Yes	1/5/2018
4	7/11/2017		NA
5	8/23/2017	No	NA
6	Unknown	Yes	#VALUE!

<tbody>
</tbody>

 

[Eric W]

Welcome to the board.

Try:

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