+ Reply to Thread
Results 1 to 2 of 2

Returning Date based off Value

  1. #1
    Registered User
    Join Date
    05-31-2019
    Location
    United States
    MS-Off Ver
    2019
    Posts
    7

    Returning Date based off Value

    I have a working formula of my attachment for reference. In the Working Example tab you will see that in column G a date is returned based off the values in F. Based on the inventory value column G will show the last date that I will have enough inventory.

    I took the formula from the working example and tried to convert it into my report but it wouldn't work. The Data Set tab is the actual format of the data I work with. The Summary tab is where I will need the date to be reflected just as it is in the Working example tab.

    Any help is appreciate. Thanks
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Returning Date based off Value

    Corrected in attached file. You have to map all the cell references and change the column offset from 1 to 15.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/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. Returning a value based on the date
    By sungen99 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-01-2015, 12:44 PM
  2. Returning a value based on date range
    By Chris.Williams81 in forum Excel General
    Replies: 6
    Last Post: 05-14-2015, 06:22 AM
  3. Returning data based on date and value
    By roykeane1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-12-2013, 03:59 PM
  4. [SOLVED] Returning a date based on criteria
    By tsmor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2013, 07:55 PM
  5. Returning Values based on date falling between Date ranges
    By honest1122 in forum Excel General
    Replies: 5
    Last Post: 06-29-2012, 05:10 PM
  6. Excel 2007 : Returning Value Based on Changing Date
    By aram87 in forum Excel General
    Replies: 2
    Last Post: 02-11-2010, 04:46 AM
  7. Returning the date based on conditions
    By itty in forum Excel General
    Replies: 1
    Last Post: 03-06-2005, 05:50 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