How to count the nearest future date based in Patient Index umber

Question

Patient Index Number&nbsp; &nbsp;Adm Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dis Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Next Date1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27/11/2021&nbsp; &nbsp; &nbsp; &nbsp;1/12/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27/6/2022&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27/6/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/12/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27/6/20222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4/2/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9/2/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;29/7/2022&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4/2/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9/2/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;29/7/2022&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19/11/2021&nbsp; &nbsp; &nbsp; &nbsp; 23/11/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/7/2022&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/7/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/11/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/7/2022&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 29/8/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;23/11/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/7/2022&nbsp;&nbsp;Hi, I would need some help with regards to Excel. Right now, assuming I have patient index number admin date and dis date. Based on the index number, I would like to find the nearest future next date based on the Adm Date given.&nbsp;For example, from index number = 1, there are two adm Date: 27/11/2021 and 27/6/2022. Since the Dis Date is showing 12/1/2021, the next date would be output as 27/6/2022 since 27/11/2021 is before the date 27/6/2022.&nbsp;Simiarlity for index number = 3, there are 3 adm Date: 19/11/2021, 7/7/2022 and 29/8/2022, since the Dis Date is showing 23/11/2021, the next date would be output as 7/7/2022 since 19/11/2021 is before 23/11/2021 while 29/8/2022 is later than 7/7/2022.&nbsp;I would like to use the formula and output as from column D. How should I do it?&nbsp;&nbsp;

hecatonchire · Answer

Hi&nbsp;Why 29/7/2022 for 2 ?&nbsp;=MINIFS($B$2:$B$8,$B$2:$B$8,"&gt;="&amp;MAXIFS($C$2:$C$8,$A$2:$A$8,A2),$A$2:$A$8,A2)&nbsp;&nbsp;&nbsp;evilgreenred&nbsp;

hansvogelaar · Answer

evilgreenred&nbsp;
Reposted as How to get output for the next appointment date based on admission date in Excel&nbsp;

Forum Discussion

How to count the nearest future date based in Patient Index umber

Share

Resources