+ Reply to Thread
Results 1 to 2 of 2

Calculating future date

  1. #1
    Registered User
    Join Date
    09-11-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2006 ?
    Posts
    1

    Calculating future date

    At my work we need to calculate when a patient is to come back to the office for a visit. There is also a window included in this. For instance:

    Patient is seen on day one. I would like to enter that date in excel and get the following:

    Week 4 with a window of + or - 3days
    Week 16 with a window of + or - 7days
    Week 24 with a window of + or - 7days

    These values vary from time to time and would have to be changed. For instance the next time I may need to enter day one and get 5 more visits: day 3 (no window), day 8 (+3day window), day 15 (+ or -5 day window), day 28 and day 57 (+ or - 7day window)

    The outcome fields would show the exact date that the person is to return with the next column showing the window. See example below:

    I would enter: Friday Sept. 11, 2009

    I would get:

    Day 3 _________9/13 ___________ no window
    Day 8 _________9/18 ___________ 9/18 - 9/21
    Day 15 ________9/25 ___________ 9/20 - 9/30
    Day 29 ________10/9 ___________ 10/2 - 10/16
    Day 57 ________11/6 ___________ 10/30 - 11/13
    Last edited by Jmntgmry18; 09-11-2009 at 07:06 AM.

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: Calculating future date

    Well your second column would look like this:
    =<date entered cell> + 3
    =<date entered cell> + 8
    =<date entered cell> + 15

    You'd be better off splitting your third column in two -
    ="no window", ="no window"
    =<day 8 cell>, =<day 8 cell + 3>
    =<day 15 cell> - 5, =<day 15 cell> + 5

    HTH

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1