Forum Discussion
evilgreenred
Mar 14, 2023Copper Contributor
How to get output for the next appointment date based on admission date in Excel
Hi, I would need some help with regards to Excel as I am still stuck with this problem. Right now, assuming I have patient index number, adm. date and dis. date. Based on the index number, I...
- Mar 14, 2023
HansVogelaar
Mar 14, 2023MVP
In D2:
=IF(COUNTIF($A$2:$A$9,A2)=1,B2,MINIFS($B$2:$B$9,$A$2:$A$9,A2,$B$2:$B$9,">="&C2))
Fill down
- evilgreenredMar 14, 2023Copper ContributorThe formula is not working though. What should I do if I need the date instead?
- HansVogelaarMar 14, 2023MVP
- evilgreenredMar 14, 2023Copper ContributorSorry, manage to work now. I think I set the wrong date using D/M/Y instead of M/D/Y.