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

Greetings all, I'm running into an issue with part of an INDEX MATCH array and don't know how to resolve it. Context: Manager asked that I setup a table to calculate the average calls offered to agents on a 30 day rotation against the days they are WFH (work from home). So, I need needed to...

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