A nagging date/recurring event proof?

markg2 · #1 09-23-2017, 07:50 AM

I think Excel can quantitatively resolve a nagging problem/question. Presuming so, the involved Excel mechanics are way above my ability.

Given:

I request a prescription to be written every 90 days for a medication that requires the pharmacy (mail order) to be in possession of the physical prescription and not a fax. The prescription must be mailed.

USPS transit + pharmacy processing time = 2 1/2 weeks.

The provider had written the prescription several times. For each subsequent refill prescription after the initial, he would write the prescription 2 1/2 weeks in advance of the end of 90 days and I would mail it.

Then the provider said he would stop writing the prescription 2 ½ weeks in advance. Going forward, as long as the prescription was written 90 days from the date he last wrote it, the 2 1/2 week transit/processing time was now 'built in' to the time frame.

I’ve been coming up a bit short at the tail end of the 90 days. Either I’m inadvertently taking extra tablets (5/day) periodically or his ‘the 2 ½ weeks are built-in’ isn’t.

I’m hoping that Excel in the proper hands can resolve the question fairly simply?

Mark

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
saving a Proof	fgrubercpa	Word	2	07-06-2016 08:59 AM
Outlook 2003 question about deleting recurring event	caltroon	Outlook	0	06-03-2015 07:00 PM
Idiot Proof Entry with InputBox	arpirnat	Word VBA	1	04-27-2015 10:03 PM
How to idiot proof a certificate	Frogggg	Word	3	09-27-2011 10:07 PM
How to task a event recurring in mutiple patterns?	prabha_friend	Outlook	0	02-01-2011 02:19 AM