Forum Discussion
How to count the nearest future date based in Patient Index umber
Patient Index Number Adm Date Dis Date Next Date 1 27/11/2021 1/12/2021 27/6/2022 2 ...
Hi
Why 29/7/2022 for 2 ?
=MINIFS($B$2:$B$8,$B$2:$B$8,">="&MAXIFS($C$2:$C$8,$A$2:$A$8,A2),$A$2:$A$8,A2)