+ Reply to Thread
Results 1 to 3 of 3

Use Vlookup to take an average between 2 dates

Hybrid View

  1. 07-19-2013, 05:38 PM #1
    coolwhip
    coolwhip is offline
    Registered User
    Join Date
    03-22-2013
    Location
    north dakota
    MS-Off Ver
    Excel 2010
    Posts
    4

    Use Vlookup to take an average between 2 dates

    Here is what I am looking to do:

    [Location] [Date 1] [Date 2] [Average Production between dates]


    Production Tab:

    [Location] [Month] [Average Daily Production]



    I need a formula to pull the average production between 2 dates from the production tab. Date 1 and Date 2 could have 6 months between them or 1.5 months etc.
    Reply With QuoteRegister To Reply
  2. 07-19-2013, 05:41 PM #2
    Mallycat
    Mallycat is offline
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Use Vlookup to take an average between 2 dates

    use a pivot table. http://spreadsheets.about.com/od/dat...ivot_table.htm
    My approach to providing help is to help you to help yourself. So my answers won't always solve your problem, but hopefully you can learn enough to solve the problem yourself and be more self sufficient for the experience.
    Reply With QuoteRegister To Reply
  3. 07-19-2013, 05:44 PM #3
    coolwhip
    coolwhip is offline
    Registered User
    Join Date
    03-22-2013
    Location
    north dakota
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Use Vlookup to take an average between 2 dates

    The value going into that cell will be used for other formulas in the sheet
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average if between two dates...
    By rybussell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-15-2013, 09:17 PM
  2. Average between dates
    By NickiName in forum Excel General
    Replies: 3
    Last Post: 05-06-2011, 08:01 AM
  3. Using AVERAGE/MAX/MIN for Dates
    By birddog2008 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-20-2009, 12:57 AM
  4. Average based on multiple conditions - Average of workdays between two dates based on
    By en_pass in forum Excel General
    Replies: 1
    Last Post: 03-12-2009, 06:33 AM
  5. Average between two dates
    By Ross in forum Excel General
    Replies: 1
    Last Post: 07-12-2006, 06:05 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1