date range

I am having trouble creating a viable formula that will sum the product found on the sheet1 within a certain date range. I would like to enable it as a vlookup. Essentially, look for item one sheet1, and total sum within the month. Similar to below. Sheet1: <colgroup><col><col><col...

Hello, I have 2 goals. 1) One macro to copy the most recent .xlsx files (based on saved date) from one directory to another, where I state the specific source and target paths 2) One macro that is similar to the one above, but allows me to state a saved date range in the code, find ALL .xlsx...

Hi Everybody, I am trying to get a formula to return a text value based on a couple inputs. Where I am running into trouble is that one of the inputs wouldn't be a match, but would be a date between a start/end date within the range it is looking at. Does anybody have any ideas on how I could...

Hi all, Just want to know if it's possible to do an Index Match Match between a date range? So what I have is a column with a date start (K2:K54) and a column with a date end (L2:L54) on a worksheet called Data. I have the data I want to return from this range N2:U54. On this Data worksheet I...

Hello all, Wondering if anyone can help me with my query; I've a spreadsheet Sheet 1 contains <colgroup><col><col span="2"></colgroup><tbody> <colgroup><col><col><col></colgroup><tbody> Date From To 01/01/2018 07/01/2018 Name Time Name 1 07:00:00 Name 2 Name 3...

Hi, I need help with the following. I would would like to search a cell for date range and then retreive information from another cell. eg: If the Date of a cell is within the month of March, then the cell will retrieve information from another cell and display it. A1 03/1/2018 B1...

Hello, I have been facing a "lookup" problem for most of the day today. I have tried vlookup and index-match, however I am unable to return the resulting values that I am looking for. Thank you in advance for your assistance. In short, I am trying to do accomplish two things. These two...

I need a formula column M to reflect CRITICAL, CURRENT, FUTURE based on text and/ date range within column K. Column K <tbody> 1-Aug-2018 31-Oct-2012 31-Oct-2014 Ended 31-Oct-2020 31-Jun-2017 30-Oct-2017 None Announced 30-Mar-2018 TBD </tbody> If Column K contain...

Hello - I'm a beginner in Excel so my question may be very simple. I've gone through several threads for the past 45 minutes and cannot find one like this. I believe I may not need a Vlookup or an IF but possibly a INDEX and Match nested formula. I would be eternally grateful if you could assist...

I have a worksheet that pulls a list of data from another sheet and I was able to create the formula so repeating data does not reoccur on my list. My problem now is that I need to edit this formula further to only include data for a certain date range. Here is an example of the data sheet...

Hi Everyone, I am working on a document trying to compile monthly purchases of parts for the year. The biggest obstacle I am facing is that the pricing for different parts changes at different points throughout the year. Currently I have one table listing each part with the effective and...

Hey Guys, Desperately need some help here. I have a column where I need to - lookup a date and see if it falls in-between two dates displayed on another sheet - Make sure the dates it is looking up are for the correct advertiser What I need it to return is either 'Active" or "Previous IO" if...

Hi Everybody, I work for a company that has a lot of projects with a deadlines, usually we prepare for our projects 110 days in advance, so if the project is due to be finished on 01/07/2017, we need to start planning 13/03/2017, so we just substract the 110 days from the date and get our date...

So I need to compute the average number of days between two columns, with multiple instances of each start and end date, across multiple sheets, and only including cells that occur in a row with a matching value. =AVERAGE(DAYS(IF(MATCH(B4,INDIRECT("'" &SHEETLIST& "'!$B3:$B300")),INDIRECT("'"...

I have a list of projects that have a start and end date in an excel file. I want to find out how many projects were live for each month. For Example, here is some data: Project 1 started 11/1/2014 and ended 10/31/2015. Project 2 started 12/1/2014 and ended 3/30/2015. From that data, I need a...

Hi there, Thanks for looking. I'm not bad at excel but visual basic is alien to me. I have a macro to extract a list of records if it's today's date. It works great. But rather than extracting only today's date, I'd like it to include the past 2 weeks as well (ie - date range From: minus 14...

I am new to excel and self teaching, most likely doing it all the long way but every day is a learning day I am attempting to extract information from worksheet 1 into worksheet 2. Worksheet 1 is a record of employees and their hours worked on a daily basis for the full year. 1 employee in...

I am trying to apply conditional formatting that will highlight a row from column A to O if the following conditions are met. =$K3<= today () this should highlight the row with grey shading This is to highlight any row where the date has passed =And($K3-today()+20,$K3-today()<=26) which...

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