Results 1 to 2 of 2

Return a value between 2 dates within a range of dates

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    Bolton, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    20

    Return a value between 2 dates within a range of dates

    I would like formula that will return a value in a cell if the dates fall between a range of dates. I have a date in B1 and other date in B2, with the total in B3. The value to be return is in B3 in all cases and to be placed in either B6 or B7 if the date falls between certain date range of C6:D6 or C7:D7. I have attached the spreadsheet.

    Thanks
    Attached Files Attached Files

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