I'm not an Excel expert (not by far) and I've been having a hard time finding a solution for the following problem. I have a table that represents the scheduled day of shift (A) for each employee (B) and I'm trying to come up with a formula whose outcome should be (for each row) the next shift of that employee after a given reference date (F1).
I've tried (found on the web) with
COUNTIF (formula below) but the result is the same date for each row whereas I'd like to find the "next date" > reference date (F1) for each employee:
In column C is the following formula:
In column D the outcome I'd like to get.