+ Reply to Thread
Results 1 to 3 of 3

Calculating Dates.

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    gainesville, florida
    MS-Off Ver
    Excel 2007
    Posts
    16

    Calculating Dates.

    Hello,

    I'm trying to create a spreadsheet using I can calculate dates using different columns. Attached you will a sample spreadsheet. Using column B, I would like calculate the next appointment which will be 90 days from the initial orientation in Column C. However I want the date to change once I put a date in Column D. For example, Name Peachy Strawberry Initial Orientation was conducted on 6/7/15 and her Quarterly is scheduled for 10/7/15. However, the quarterly visit was completed 10/1/15. Is there a formula that could change the Quarterly Scheduled to reflect her next quarterly visit?
    Attached Files Attached Files

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Calculating Dates.

    Something like...

    =IF(ISNUMBER(D2),D2+90,B2+90)

    -Moo

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Calculating Dates.

    Or this

    This formula will leave cell blanks if D2 is empty

    =IF(D2="","",IF(D2<>"",D2+90,B2+90))
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating a future dates based on dates or birth.
    By CDobby in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 07-31-2012, 11:22 AM
  2. Calculating Eligibility Dates & Hiding negative Dates
    By Dooger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2012, 04:01 PM
  3. calculating the # of days btwn 2 dates INCLUDING the dates
    By jfarlow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2008, 12:27 PM
  4. Replies: 4
    Last Post: 10-31-2005, 05:05 AM
  5. Replies: 5
    Last Post: 10-26-2005, 02:05 PM

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