Results 1 to 3 of 3

Taking 3 dates and solving for a yes no value

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2010
    Location
    Illinois
    MS-Off Ver
    Excel 2003
    Posts
    22

    Taking 3 dates and solving for a yes no value

    I appreciate the help from my last question, hope this one will be just as simple for you excel guru's.

    My issue this time is I want them to input 3 dates.

    A1 DATE1
    B1 DATE2
    C1 DATE3

    Need to figure out if DATE1 is within 120 days before or after DATE3 AND also must be prior to or same as DATE2 to say yes

    if DATE1is not within 120 days from DATE3 OR its not before DATE2 will say no.

    any takers? thanks in advance.
    Last edited by Argile79; 04-13-2010 at 05:23 PM.

Thread Information

Users Browsing this Thread

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

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