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 `LARGE`

+ `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:

```
=IFERROR(LARGE($A$2:$A$12;COUNTIF($A$2:$A$12;">"&$F$1));"").
```

In column D the outcome I'd like to get.