date range

I need to compile a list of item qtys across a weekly grid for reporting purposes. My original sheet is a list with duplicates. How do I arrive at the conclusion in the second table using formulas? Right now I'm doing this manually. <tbody> ITEM QTY SHIPPED IN-HOUSE DATE (OR EST) WEEK...

Hi I am looking help for a formula concerning values and dates in a range. Table 1 consist of aggregate audit values at specific dates. These audit values represent the sum of values between the dates. Table 1 <tbody> Audit values 3.1.2017 5.1.2017 9.1.2017 Value 12 10 24 </tbody>...

Group, I have a set of daily exchange rate data spanning one year. It has been a long time since I've done this and I am really struggling... Data Set A............... B............C...........D Date.......... CAD.........EUR........GBP 01/01/2016 0.722932 1.086970 1.473860...

Endeavouring to add up the values for rows that match on TeamCode and that the Workday falls in a range. Let A1 = 'Team1' Let B1 = '30/11/2016' Let C1 = B1 - 90 days Named column ranges: <tbody> Workday ScheduledHours WorkedHours TeamCode 21/11/2016 8 11 Team1 21/11/2016 7 5...

Hi I tried to use the INDEX and MATCH stuff, but cannot work out how to do this where Variable1 in STAFF and Variable2 between DATEFROM and DATETO Data <tbody> STAFF DATEFROM DATETO TEAM AB 01/11/2016 30/06/2021 TEAM1 ANV 01/11/2016 08/12/2016 TEAM1 ANV 09/11/2016...

Hello, I am trying to automate a report request form, which currently automatically provides a completion date depending on the severity of the report, however, what I would like it to do now is add 4 days onto that date if the date is within the first 7 days of the month. This is because the...

Hi, I need to create a dynamic table that helps with backplanning from a specified date and time. It's meant to be used for project management, so I essentially something like this: If someone enters data into the blue boxes the full table should populate with dates and times in the format...

Hello All, Thanks in advance for any help you can give me. I need to extract a unique list of names from two columns of names, but only names that fall within a given date range. I would also like for the extracted list to be sorted alphabetically a-z. The datasheet is a list of "deals" for...

hi guys, I am stuck on an excel problem. I have thousands of cells of data. In one column I have manually entered dates. Sometimes the date is a single day (1/1/2003). Other times it is a manually entered date range (1/1/2003-5/1/2003). A few columns later each entry has a numerical value to...

Each week I have a spreadsheet in which column A has the start date and column B has the end date of an event, unless it is a one-day event in which case column B is either blank or has the same date as column A. I needed to create a new text column that contains the date reformatted into one of...

Hello, I was hoping someone could give me a hand trying to figure out some code. I have a sheet within a workbook that pulls data from another sheet containing my companies bids on projects. It checks against records we have and adds the word "GAINED" to a column and highlights it red. Sheet is...

Hello all, I'll get right to the point... I have 2 sheets Sheet1 <tbody> A B C 1 Bill Murry 05/14/2007 WI 2 Bill Murry 02/20/2008 TX 3 Bill Murry 11/12/2008 NY </tbody> On my second sheet I have <tbody> A B C D 1 Bill Murry 03/02/2007 08/04/2007 **Formula** = WI 2 Bill Murry...

Ok, here's my problem: Sheet A: In A4:A I've got dates (actually in an ascending order) In H4:H I've got numbers (that are not supposed to sum, only LAST number is always significant) In all other columns I've got numbers to sum up. Sheet B: (Sums up data in months) In A4:A I've got MONTHS...

Hello, In my Excel worksheet, I have a pivot table which I want to filter by a given date range. The two dates (From & To) are also on the same worksheet but on a different tab. I have below macro but it doesn't seem to work. Can anyone please help me? Dim Pt As PivotTable Dim PeriodField As...

Good Morning, I am attempting to count the number of Cells which contain a specific text string and fall within a date range. The formula I have right now is as follows: =IFERROR(COUNTIFS(C:C,"*&A385*",AP:AP,">=E385",AP:AP,"<=F385"),"ERROR") C:C contains the range with text in which I am...

I've got a date attribute in "dd\mm\yyyy" format in a sheet and I'm trying write a macro, which filters plus minus 7 days from TODAYS date. For example If today's date is 14/06/2016 my filter range will be 07/06/2016 to 21/06/2016. I specifically need help with adding and subtracting from...

I need to be able to enter a date range and know if the Start Date, End date or any day in between falls within the date range. Example below. Does anyone have any ideas of formulas that I can use? <tbody> Start Date End Date Date Range Y/N 12/14/15 1/20/16 1/1/16-1/31/16 Y 12/1/15...

Hi, decided I've spent enough time fumbling with this, time to ask for help. The RED section or 'criteria range 2' of this sumifs formula is what I need some help on. Column H = Duration in weeks, $H$6:$H$104 Column F = Start Date Range, $F$6:$F$104 Hypothetical 'End Date' column would equal...

I already have formats for; <6months =F9>=TODAY()-180) >2years =F9<=TODAY()-730 However, I can't seem to format 7 months - 23 months.. What I've tried using is; =AND(F9>=TODAY()-213,F9<=TODAY()-700) Any idea's? Thanks

Hello everyone, I have a macro set up that asks for a beginning date and an ending date, then scans columns J-Y for a date that falls within that range. If the macro finds a valid date, it copies and pastes the cell containing the date and the cell directly to the right of it onto another sheet...