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.