freckledgenes
New Member
- Joined
- Sep 19, 2017
- Messages
- 1
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!
<tbody>
</tbody>
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>