Forum Discussion

athurmond's avatar
athurmond
Copper Contributor
Apr 16, 2021
Solved

Return next date

I created a spreadsheet that calculates upcoming well child visits for children in a program. I need to determine each client's next visit due date. What formula can I use?
excel
Formulas and Functions
  • MindreVetande's avatar
    MindreVetande
    Apr 16, 2021

    athurmond 

    My bad. MINIFS is newer than i remembered. You have to use excel 2019 or newer.

    https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599

    so, let's make an old fashioned complicated solution with AGGREGATE...

    attached again

     

    Leila explains how it works in this video (at least i assume it is the right one)

    https://www.youtube.com/watch?v=iezVva6tAE4

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 16, 2021

athurmond 

Who is the "client" in terms of the spreadsheet and what is the logic, which date shall be next due date? Perhaps you may add at least one desired result manually to illustrate.

  • athurmond's avatar
    athurmond
    Copper Contributor
    Apr 16, 2021
    Look at the spreadsheet now and you will see what I am trying to do.
  • athurmond's avatar
    athurmond
    Copper Contributor
    Apr 16, 2021
    On the spreadsheet, the clients are listed by case # in the first column. Each row lists upcoming well visits for each client. I need the next upcoming visit due date. I will try to add a sample of what I want.