This is Going to be complicated but here goes:
I Have a medication I receive 1 injection every 3 months, the medication contains 6 Vials
the complication is:
I want a
Name of Medication
Prescription Start Date
Prescription Renewal Date
An a automatic count down of vials and if <=0 text stating Overdue
# of Repeats
Ex Name of Prescription Prescription Medication # of
Medication Start Date Renewal Date Remaining Repeats
B12 Injection 20/02/2022 20/01/2023 1 0
Ex Name of Prescription Prescription Remaining # of
Medication Start Date Renewal Date Medication Repeats
B12 Injection 21/01/2021 21/12/2012 Overdue 0
No Sheet to work from as yet as still working out formulas, sorry
I Have a medication I receive 1 injection every 3 months, the medication contains 6 Vials
the complication is:
I want a
Name of Medication
Prescription Start Date
Prescription Renewal Date
An a automatic count down of vials and if <=0 text stating Overdue
# of Repeats
Ex Name of Prescription Prescription Medication # of
Medication Start Date Renewal Date Remaining Repeats
B12 Injection 20/02/2022 20/01/2023 1 0
Ex Name of Prescription Prescription Remaining # of
Medication Start Date Renewal Date Medication Repeats
B12 Injection 21/01/2021 21/12/2012 Overdue 0
No Sheet to work from as yet as still working out formulas, sorry