date range

  1. S

    LARGE Function using a date range

    Im trying to show the Top 5 performers within a date range using the units per hour (column G) At the moment im using the following formula (for first place) which gives the answer i need but you have to manually put in the date range. =LARGE('Sheet 1'!$G$2:$G$60,1) I want the user to be able to...
  2. ncsushley

    Array formula with lookup based on multiple criteria including a date range

    I tried to find help with this question on Stack Overflow here but did not get a complete answer. I use this Google sheet to track proofreading jobs. I'm trying to modify the array formula in P1 that calculates the billable total for each job. The formula currently uses the Turnaround and...
  3. N

    Multiple Criteria Lookup with Date Ranges

    Hi everyone, I need to create a lookup which returns a value based on 1.) an employee ID 2.) a date range. I have included an example image. Basically, I need a formula for column H which returns the correct Union of an employee, based on their ID and the award date (column G). The dataset...
  4. S

    Index/Match Formula - Sum if falls between a date range

    Hi all, Please can someone help? :-) I am trying to find a tidier version of the below formula - what I am trying to do is basically add up the values in row 2 for the week before. The displayed dates are Mon-Fri (not inc Sat-Sun). Note, the below formula would be in cell F3, so on the 2nd...
  5. H

    Counting in date range with 2 criteria

    Evening everyone, I hope you may be able to help. knowledge of Excel is okay, however I am struggling with this one and any help would be appreciated! I need to calculate the total of payments paid from a certain person based on a date range for over 300 people. For example in the following...
  6. N

    Unit count between Start- & EndDates

    Hi all, I'm relatively new to Power Bi and I looked at a couple of questions on the forum, but I couldn't find the right answer. I hope some of you could help me. I have a field which included a StartDate and a field with an EndDate. Between those dates, certain units should be built (let's...
  7. S

    Populating worksheet with a range of dates from a UserForm

    Greetings, I'm making my way up slowly but surely to get better at VBA coding but the road is still long thus I humbly request for any assistance from your side :pray: I actually have a worksheet as per below: <tbody> A B C D 1 Date Item X Item Y Item Z 2 3 4 5...
  8. H

    Count cells containing text string, based on date range and additional condition

    <tbody> A B C D E F G H I 1 Date Red Blue Red Green Blue Red Green Green 2 02 Jan 2018 x x x, y x y x 3 11 Jan 2018 x, z x 4 24 Jan 2018 z x x z y 5 04 Feb 2018 x, y 6 15 Feb 2018 z y x, z x x, y 7 07 Mar...
  9. D

    Searching with date range and other variables.

    I am wanting to search a price table with a number of columns; store, product, date range (from /to) & price. I have the elements I of the store , product and exact date within the range an looking to get the price as an output. I have tried all sorts and can't get a working approach, this is...
  10. C

    Dates in different formats to be ordered chronologically

    Hi, Total excel amateur here. I am compiling a list of documents and wish to order them in chronological order. However some of the documents have a single date while others have date ranges. The straight forward dates are fine and ordered correctly however Excel is not recognising the date...
  11. M

    How to sum multiple column values based on multiple date ranges and resolve into date range summary?

    Hi excel help community, I have a sheet that collects our planned scaffold tower quantities by type for each bridge we have with an associated date range of use. I would like to sum scaffold type in use by month (see below) to enable us to produce a histogram of scaffold type over several...
  12. E

    Vlookup with 2 criteria

    I need help with a formula to look in a chart & (1) identify brand, (2) determine if a date is between to dates, and (3) return a value of a corresponding event. Here is a snapshot of the data: <tbody> Brand (Col. A) Event (Col. B) start (Col. C) end (Col. D) Brand A Winter Clearance...
  13. E

    Assigning value based on date range & another criteria

    Hi, Hopefully someone can help me. I have a chart that lists dates of two brands and some events that run each year for past 2 years. In another tab I have a list of dates between the two brands. I want to first, identify the brand, then if the date falls between the date ranges of a certain...
  14. M

    Date Range Formula Help

    Hello, I am looking for a formula that will look at the dates in two columns, and return the sum of another column if those dates are included in a certain month. For example below. The first table, is where my data is stored. The second table, I want to return the sum of resources needed if...
  15. B

    How to Find specific date in X number of days from within multiple date range?

    Hi, I want to calculate a specific date after x number of days from within following date-range only (table given below)! <tbody> Trip# FROM TO DAYS 1 12-MAR-2015 24-AUG-2015 165 2 20-AUG-2015 15-FEB-2016 179 3 24-MAR-2016 17-AUG-2016 146 4 20-MAR-2017 22-JUN-2017 94 5 19-MAY-2018...
  16. D

    Help with linking events in one table to specific location in another table

    Good morning! We are a healthcare provider and need to track where falls occur. Patients can be in one or more locations and have one or more falls in a perod. I've been trying to use INDEX/MATCH functions to identify the location for each fall, by first identiying the patient by their ID...
  17. R

    Vlookup date range and result based on criteria

    Dear friends, I required your help for the below excel query: The following is the data set sample: <colgroup><col><col><col></colgroup><tbody> Class. Date Reg.No Course 12/05/2017 123456 ? 19/05/2017 123456 ? 30/05/2017 123456 ? 02/06/2017 901999 ? 09/06/2017 901999 ...
  18. A

    SUMPRODUCT for range of dates

    Hi all, I've had a look through MrExcel (and other websites) and I'm struggling to adapt the answers found there to my problem. I currently have the following that refers to a single date (K2): =IF(SUMPRODUCT( -- ($J$2 = Data'!$Y$2:$Y$5000), -- (AF5=...
  19. S

    Listing Missed Details in New Table

    Hi Masters, I need the solution for following situation in the Table-01 contains all the details; Table-02 has missing sum data Now in the Table-03, I want the list of missing details given date Range in 'E16 + G16. Thanks In Advance. <tbody> Table-01 Table-02 Table-03 Date...
  20. T

    Index and Match - with 2 criteria AND a date range...

    Hello, I have a doozy here and any and all help is truly appreciated. I am trying to create an Index and Match function that is looking for 2 criteria - a user ID and a date within a range. I have created this array that is looking for the user ID and the specific date...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top