date range

I've tried using =NETWORKDAYS and it does work, but it excludes the start and finish dates. Is there a method that will count weekdays in a range while including and the start and end in that range? example: Start date: July 8th, 2020 End date: July 15th, 2020 NETWORKDAYS: 4 Desired count: 6

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...

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...

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...

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...

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...

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...

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...

<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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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=...

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...