+ Reply to Thread
Results 1 to 5 of 5

Formula needed for future date using variable text from 1 column and dates from another.

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Isle of Skye, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Formula needed for future date using variable text from 1 column and dates from another.

    Hi folks,

    I currently have a formula in column I...

    =IF(H2="","",IF(H2="N/A","N/A",DATE(YEAR(H2),MONTH(H2),DAY(H2)+7)))

    ...which works great, however I now need to vary +7 to +14 depending on what I have in column B, whilst still maintaining the reference to the date in column H.

    I'm a complete novice and can't figure out how the formula should be written to add +7days from the date in column H if column B reads Priority and +14 from the date in column H if column B reads Standard.

    Any help would be greatly appreciated as I can't seem to find a solution elsewhere on the forum, though I'm sure there is probably an answer there already for it, I just can't find the right terminology to pinpoint it.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,278

    Re: Formula needed for future date using variable text from 1 column and dates from anothe

    =IF(ISNUMBER(H2),H2+IF(B2="Priority",7,IF(B2="Standard",14,0)),"")
    Try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    10-19-2012
    Location
    chennai
    MS-Off Ver
    Excel 2013
    Posts
    134

    Re: Formula needed for future date using variable text from 1 column and dates from anothe

    hi,

    try this,

    Please Login or Register  to view this content.
    RoyalRajan

  4. #4
    Registered User
    Join Date
    10-02-2013
    Location
    Isle of Skye, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Formula needed for future date using variable text from 1 column and dates from anothe

    Wow fantastically fast response nflsales and works perfect.

    Thanks a million.

  5. #5
    Registered User
    Join Date
    10-02-2013
    Location
    Isle of Skye, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Formula needed for future date using variable text from 1 column and dates from anothe

    Thanks rajansettu also, your solution works perfect too. I'm now spoiled for choice.

    Excelforum rocks!

+ 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] SUM column based on two dates, SUM function begins at first date which is a variable
    By moxiepilot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2013, 06:36 AM
  2. Change colour in column C based on Column B - future dates
    By kfwiss in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2013, 05:47 AM
  3. Formula to calculate future date; applied to whole column
    By DainaHiggins in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2013, 01:51 PM
  4. Replies: 4
    Last Post: 08-23-2011, 07:42 AM
  5. [SOLVED] [SOLVED] Dates are saved with a future date
    By Eates-a-Lot in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-22-2005, 11:05 AM

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