I am looking for a formula that will COUNT the number of cells in a row that:
a. Is populated with data
b. Is in the same column as a date that takes place in the future (after today’s date)
In the example below, the expected result is 3 since there are 3 cells that are populated and also are in columns with corresponding dates that happen in the future. The populated cells with dates in the past are ignored in the count.
Any assistance would be appreciated!
New contributor
Chris Thompson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.