Creating a count down

[EOO7L]

I would like to automatically count down how many pills I will have left each day using the following:

Today's Date	Name	MEDICATION	THERAPUTIC CATEGORY	Amount of pills received today	HOW MANY TIMES PER DAY CLIENT TAKES MED?
7/27/2022		Lasix	CARDIOVASCULAR	30	1
7/27/2022		Metformin	ENDOCRONOLGY	70	2
8/5/2022		Aripiprazole	PSYCHIATRIC	40	2
8/5/2022		Trazadone	PSYCHIATRIC	21	1

 

[Ezguy4u]

EOO Let's get the ball rollin. Now this usually generates more questions than answers, but we have to start some place. So I haven't tried every scenario, but as time goes by let us know if this is the solution to your problem.

22-08-12.xlsx
	A	B	C	D	E	F	G	H	I
1	Today's Date	Name	MEDICATION	THERAPUTIC CATEGORY	Date Received Pills	Amount of pills received today plus left over pills	HOW MANY TIMES PER DAY CLIENT TAKES MED?	Pills Left	Reorder pills before date below
2	Friday, August 12, 2022		Lasix	CARDIOVASCULAR	Wednesday, July 27, 2022	30	1	13	Thursday, August 25, 2022
3			Metformin	ENDOCRONOLGY	Wednesday, July 27, 2022	70	2	36	Tuesday, August 30, 2022
4			Aripiprazole	PSYCHIATRIC	Friday, August 5, 2022	40	2	24	Wednesday, August 24, 2022
5			Trazadone	PSYCHIATRIC	Friday, August 5, 2022	21	1	13	Thursday, August 25, 2022
Data

Cell Formulas
Range	Formula
A2	A2	=TODAY()
H2:H5	H2	=(F2-G2)-(($A$2-E2)*G2)
I2:I5	I2	=(E2+(F2/G2))-1