View Single Post
 
Old 09-23-2017, 07:50 AM
markg2 markg2 is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default A nagging date/recurring event proof?

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
Reply With Quote