+ Reply to Thread
Results 1 to 2 of 2

Help with IF statement formula using date ranges

  1. #1
    Registered User
    Join Date
    02-02-2015
    Location
    Massachusetts, USA
    MS-Off Ver
    Excel 2010
    Posts
    0

    Help with IF statement formula using date ranges

    Hi,

    I would like to create 3 separate date ranges for upcoming deadlines to be displayed as 1, 2, and 3 based on how close the deadline is to the current date. Range 3 is over a year away, range 2 is between 6 months and a year away, and range 1 is less than 6 months away. I have a cell dedicated to today's date (not sure if that is necessary) and I've come up with the following formula from reading different pieces of help forums:

    =IF(AND(G2>=J2+365,"3") , IF(AND(G2>=J2+183,G2<J2+365,"2") , IF(AND(G2<J2+183,"1"))))

    J2 is the "Today's Date" cell, and I'm hoping to carry this formula down the entire G column. If anyone can help that would be awesome. Excel is telling me the formula is broken.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello blynch1023,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. IF Statement that populates a Month based off of specific Date Ranges
    By cmorten82 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-12-2014, 11:37 AM
  2. Nested What If statement using date ranges
    By Glenn1 in forum Excel General
    Replies: 3
    Last Post: 01-08-2012, 04:13 PM
  3. Nested What IF excel statement with date ranges
    By Glenn1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2012, 01:47 PM
  4. Nested What If statement using date ranges
    By Glenn1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2012, 01:41 PM
  5. Replies: 10
    Last Post: 02-22-2009, 02:44 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