+ Reply to Thread
Results 1 to 4 of 4

IF/Then Formula to add to a date depending if a number falls w/in a certain range

  1. #1
    Registered User
    Join Date
    05-03-2019
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    3

    Question IF/Then Formula to add to a date depending if a number falls w/in a certain range

    I am trying to figure out a formula that would allow me to add a certain number of years to a date depending on the associated number. For example, if the number is between 90-100 3 years will be added to the date, if the number is between 80-89 then 2 years would be added and if the number is 79 and below then 1 year will be added to the date. For example,

    90 (1/1/2019) {one cell} ----> 1/1/2022 {the associated cell}
    80 (1/1/2019) {one cell} ----> 1/1/2021 {the associated cell}
    79 (1/1/2019) {one cell} ----> 1/1/2020 {the associated cell}

    thank you and this is my first post so if I need to change something let me know.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: IF/Then Formula to add to a date depending if a number falls w/in a certain range

    IF value [90,80,79 etc.] is in B3 and date is in C3, then in D3 use this formula:

    HTML Code: 
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Registered User
    Join Date
    05-03-2019
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    3

    Re: IF/Then Formula to add to a date depending if a number falls w/in a certain range

    Thank you for your response. The number and the date share a cell. Is there a formula for that? If not I can always put the date in its own cell!

    Also, it is a range of numbers ex. 80-89!
    Last edited by RMFM55; 05-06-2019 at 09:22 AM.

  4. #4
    Registered User
    Join Date
    05-03-2019
    Location
    Boston, MA
    MS-Off Ver
    2016
    Posts
    3

    Re: IF/Then Formula to add to a date depending if a number falls w/in a certain range

    Thank you, with your help I have been able to have a working formula! now a happy excel novice:-)

+ 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. Calculate Number of weeks/months falls under each year between date range
    By dhitpit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2017, 10:06 AM
  2. sum depending the number falls
    By managingcrap in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2014, 02:07 PM
  3. [SOLVED] Formula to assign specific numbers if a date falls within a certain date range
    By headley4ever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2014, 04:16 PM
  4. Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  5. Replies: 1
    Last Post: 01-17-2013, 10:44 AM
  6. Assignment of number depending on range it falls into
    By joeschmo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2009, 11:33 AM
  7. Formula to determine whether number falls within range??
    By Cat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2005, 10: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