Complicated Formula Envisaged

[ozygonzo]

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

 

[earthworm]

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

Book1
	A	B	C	D	E	F	G	H	I
1	Injection	Months	Vials
2	1	3	6
3
4	Name of Medication	Prescription Start Date	Prescription Renewal Date	Quarter Available	Required Vials	Injection Taken	Applied	Available Vials	Remarks
5	B12 Injection	20-02-22	20-01-23	4	24	26-01-22	1	18
6	B12 Injection	21-01-22	21-12-12
Sheet1

Cell Formulas
Range	Formula
D5	D5	=ROUND((C5-B5)/90,0)
E5	E5	=D5*C2
G5	G5	=IF(F5<>"",1,"")
H5	H5	=E5-(G5*$C$2)

 

[ozygonzo]

Thanks earthworm I think I can work with this
Much appreciated
Paul