Creating a refill tracking log

[EOO7L]

Hi,
I am trying to find a way to automatically keep track of when the date of my next refill and the date when I will run out using the information below

TODAY'S DATE	CLIENT NAME	MEDICATION	THERAPUTIC CATEGORY	ANY DUPLICATES?	TODAY'S MED QUANTITY	DATE FILLED	PILL QUANTITY AT DATE FILLED	HOW MANY TIMES PER DAY TO TAKE MED?	NEXT FILL DATE	DATE PILL WILL RUN OUT	CRITICAL DATE TO OBTAIN MEDICATION
7/27/2022		Lasix	CARDIOVASCULAR	NO	27	7/27/2022	30	1x	<<<need this>>>	<<<need this>>>

 

[Anthony47]

Assuming that "DATE PILL WILL RUN OUT" is column K, and assuming that in column "HOW MANY TIMES PER DAY TO TAKE MED?" you insert a number (1, not 1x), then try
in K2: =INT(G2+H2/I2)-1
in J2: K2-3
This seconf formula assumes a 3 days early notification, so adapt to your need

 

[EOO7L]

Assuming that "DATE PILL WILL RUN OUT" is column K, and assuming that in column "HOW MANY TIMES PER DAY TO TAKE MED?" you insert a number (1, not 1x), then try
in K2: =INT(G2+H2/I2)-1
in J2: K2-3
This seconf formula assumes a 3 days early notification, so adapt to your need

Thank you! That works. How do you do an automatic pill count down from Today's date and Today's med quantity?

 

[Anthony47]

Thank you! That works. How do you do an automatic pill count down from Today's date and Today's med quantity?

I worked on DateFilled, QuantityAfterFilling, and PillQuantityPerDay, and calculated "DATE PILL WILL RUN OUT" (and beware I inserted "-1 day" because I cannot be sure whether the refill is early in the morning, before any day medication, or late in the evening, after all day medications)