+ Reply to Thread
Results 1 to 4 of 4

Date formula comparing TODAY and fixed date to give monthly value

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    Salt Lake City, UT
    MS-Off Ver
    Professional Plus 2013
    Posts
    54

    Date formula comparing TODAY and fixed date to give monthly value

    I'm stuck with working the TODAY feature into a formula.

    In column G I want to use TODAY to compare to the date in column E. If the difference between TODAY and the date in column E is less than three months, I want the formula to spit out "pending" in column G. If it's more than 3, "delayed."

    I was using an index formula to compare the date in column E to the first date listed in column A but it's just not accurate enough. I'm unfamiliar with TODAY except to use it as =TODAY() to spit out the date in a cell.

    Is this formula possible?
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,260

    Re: Date formula comparing TODAY and fixed date to give monthly value

    In G2, copied down:

    =IF([@[Current Processing Complete Date:]]="","",IF(EDATE([@[Current Processing Complete Date:]],3)>=TODAY(),"Pending","Delayed"))

    Is this it??
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    11-22-2010
    Location
    Salt Lake City, UT
    MS-Off Ver
    Professional Plus 2013
    Posts
    54

    Re: Date formula comparing TODAY and fixed date to give monthly value

    This is it, thank you!!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,260

    Re: Date formula comparing TODAY and fixed date to give monthly value

    You're welcome and thanks for the rep.

+ 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. Replies: 5
    Last Post: 12-01-2015, 02:36 PM
  2. Replies: 2
    Last Post: 10-22-2015, 03:36 PM
  3. Replies: 1
    Last Post: 08-26-2015, 09:31 PM
  4. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  5. Comparing Today's Date to Date in Field...
    By OneWingDove in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2013, 06:40 PM
  6. Comparing Multiple Dates to Today - Due Date Reminder
    By TheMooCow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-01-2010, 02:08 PM
  7. Comparing a date to today’s date?
    By juzsp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2007, 12:16 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