date and range

I'm trying to create a data collection tool in a research study that will only provide the last 30 calendar days from the date it is opened. I'm using Excel Calendar, and I put the information for the date ranges in two cells on the side of the calendar, where the 30-day period start date is L4...

OK, friends more capable in Excel than I, I need help creating a single cell that includes a date calculation and an if statement on a date range. A1=Date; A2=Date+3 Day; A3=Date+10; A4=Date+45. Date is something like 7/1/2016, for example, and the following cells just add to that. That’s easy...

First of all, thanks for taking the time to read and consider this question! I am very new to using VBA in Excel, and am feeling my way around the language. I have come across a situation in which I am not sure how to approach the problem for a solution. Scenario part 1: I have timesheets...

Hello, I want to select the rows based on the date and past it in other sheet. for ex: lets take today's date 24/06/2016. So now select the rows that is < 8 days and >8 days from 24/06/2016 on wards and paste it in the other sheet. Below is pic. Thank You! Regards Wither

Hello, I am looking at creating a Price Model, and I am looking at the best way to solve the problem other than having lots of columns. My data Set looks like This <tbody> Cost Type Qty Unit Mth Cost Margin Unit Sell Start Date End Date Total Mths Total Cost Total Sell A 10 $80 30%...

Hello! I have a spreadsheet that I'm using with three different sheets (Sheet1, Sheet2, Sheet3). In Sheet 1 I have a dropdown list (C4) that contains 20 types of licenses. When a license is clicked, cells c2:c4 will autopopulate with what type of test the person needs for the license (there...

Hi! Looking for some help with a formula for employee vacation requests. I need to calculate the number of days each week that are requested off based on a vacation request that lists start and end dates. Vacation requests are listed in Columns A & B, and the weeks of the year are listed in...

I've been looking through the forum for an answer, and although I've seen some very similar posts, I can't get a definitive answer for my issue: Here is an example of what I am working with and what I'm trying for my INDEX MATCH...

Hi All, Little stuck with this and can't figure out how to get it to work - any help/advice will be greatly appreciated: I have a worksheet with a list of suppliers, the frequency I pay them, payment value (amount) and date last paid. And then the start and end date of every week in the year...

Hi All I'm very new to this so I will apologise now if this seems longwinded. I have been asked to create an "Equipment Register" at work. The equipment is meant to be inspected every 3 months. Not all equipment is inspected on the same date so the inspection dates vary considerably. I want to...

Hi, I am new to VBA and have use the below code to copy rows that meet the criteria entered when prompted. Now I am trying to tweak the code to pull in dates from column K that are less than the date entered when prompted. The code works, but is also pulling in 1/1/16+ dates also. Please let me...

<tbody> Fruit ID Date Apple 2 1-15-2000 Apple 3 2-29-2011 Apple 6 3-6-2007 Apple 5 6-5-2010 Apple 2 8-21-2015 Banana 1 9-4-2014 Banana 3 6-18-2015 Banana 5 2-19-2002 Banana 4 7-3-2009 Banana 6 1-20-2005 Banana 7 2-3-2010 Banana 6 5-27-2006 Coconut 2 4-21-2009 Coconut...

I've got two table ranges: CustomerID and Date. I'd like to find out the lowest date of a particular customer and year. Example: <tbody> CustomerID Date 1 13.02.2014 2 03.04.2014 1 08.08.2014 1 01.12.2014 1 01.01.2015 6 01.02.2015 7 01.03.2015 8 01.04.2015 </tbody> I tried...

Hi all, I hope you can help me with what I would like to do. I've searched and searched and not come up with anything yet!! I have one sheet which is my 'data' sheet with a number of columns according to date. And I have another sheet which is the chart sheet. I want to populate the chart...

First off, thank you for your help and taking the time to read this. Here is the situation I am trying to solve: I have two date/time stamps per transport unique identifier, I am trying to write a formula that says if on a given date, how many active transports occurred that were not...

​ <tbody> A B C D E F G H I 1 TODAY'S DATE: WITH/WITHOUT PAY: DATE EMPLOYEE LEAVING DATE EMPLOYEE RETURNING WITH OR WITHOUT PAY 2 11-9-2015 10-30-2015 11-2-2015 WITH 3 11-7-2015 11-14-2015 WITHOUT 4 12-25-2015 12-26-2015 BIRTHDAY PAY...

Hi, I have value as below: <tbody> column A column L 03/04/2015 01/07/2013 03/04/2015 22/12/2014 03/04/2015 10/11/2014 03/04/2015 06/09/2013 03/04/2015 15/08/2014 </tbody> Now in column AA, I want to add flag "1" when, it have passed over 3 month between date from column A and...

Hi, I've got a workbook for budget variance but need the total budgeted hours to reflect only up to the week beginning of todays date as opposed to the whole year so trying the following formula; =SUMIF(C5:AH5,IF(A3>=C5:AH5,1,0),C9:AH9) where C5:AH5 = week begin dates A3=...

Hi Guys - Hoping someone can help. I'm trying to forecast my payments for the next year dependent on the frequency (Weekly, Monthly, Quarterly, Yearly) and based on the last payment date. (there is a lot data to do this manually) I have column headings which are the week ending dates...

Hello All, I am in need of a formula that returns "1" if the start date is before or on the active date and if the close date is before or equal to the active date. I am trying to determine how many project are active in that month. If the project is not active, I would like a 0 returned. Here...