+ Reply to Thread
Results 1 to 2 of 2

Returning a Dollar value if the posting date falls between two dates

  1. #1
    Registered User
    Join Date
    03-01-2014
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    2

    Returning a Dollar value if the posting date falls between two dates

    Hello,
    I am having an issue trying to get a specific value to appear if the value falls within two dates in which it was posted.

    I have the following data
    1/1/2014 in Cell AB2
    $1000 in cell M3
    1/1/2014 in cell P3
    12/1/2014 in cell Q3.

    What I'm trying to do, if Value 1/1/2014 AB2 falls between 1/1/2014(P3) and 12/1/2014 (q3), then I want it to return $1000 (M3), if it does not, then to post 0 or blank.

    How can I do this?

  2. #2
    Registered User
    Join Date
    03-01-2014
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Returning a Dollar value if the posting date falls between two dates

    Any guidance is appreciated.

+ 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] Returning a date from a range if date falls between two other dates
    By sdavison in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-25-2013, 03:59 AM
  2. [SOLVED] Value with Corresponding Date if Falls Within Range of Dates
    By ebdmbfan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2012, 09:14 AM
  3. [SOLVED] Return value in X if date in Y falls between two dates - Help!
    By nephilim3uk in forum Excel General
    Replies: 4
    Last Post: 07-08-2012, 10:13 AM
  4. Replies: 10
    Last Post: 05-13-2012, 07:43 PM
  5. returning a value if a date falls between two dates
    By chillangella in forum Excel General
    Replies: 3
    Last Post: 09-28-2009, 06:51 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