Forum Discussion
Excel IF Statement not working
I have a cell for study participants who are eligible (A2= "Yes" Or "No") They made a visit a entered in B2=15-AUG-2017. I want to create two if statements that calculate a date range for their ne...
Hi Raches,
Not sure I understood your logic. If in C2 will be next visit date or "Not eligible" when the formula for C2 is like
=IF(A2="Yes",IF(B2="","",B2+1), "Not eligible")