I am currently running formulas IF(COUNTBLANK) to self fill other cells corresponding to dates in another cell. However, what I want to determine is how to take the column of data that has some cells filled with N/A where other are filled with dates, but I don't want the cell that the formula is in to change to a Y until all the empty cells (those not N/A) have a date in it.
This is my current formula:
In the referenced cells, 17 have N/A but two will be populated with dates, I don't want the "Y" to show up until both cells have dates.