Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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: 317
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
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 03:00 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft