daterange

I'm running the attached code, it is applying the correct filter on the correct column but the results displayed are incorrect. When I manually apply the same filter, the correct results are displayed. This is very strange and I don't understand why this is happening. Any help would be greatly...

Hi. The main sheet contains information of the date and the fruits bought in each date. The second sheet (calculations sheet) contains the data I am calculating for. Issues I faced: 1) I tried for many days to calculate the total number of fruits of each fruit type with date range as the...

Hi, I was given a sheet with a list of projects. It has a start date column and and end date column, and further information about the project (title, manager, budget) are in other separate columns. I have been trying to find a way to be able to select a month and year in a pivot table and have...

Hello, I am struggling to find a solid method to find the populated cells in a row. In the capacity planning below I have a table of seat numbers and dates as headers. I want to find the daterange in every row. When there is only one daterange without blank cells in between I can do this with...

Hello, I am trying to aggregate weekly quantities into monthly ones. THIS LINK shows the dataset in question, the formula I created to aggregate these subsets, and the organization tactic I used. Is there any way I can make this formula dynamic? I feel like there is an easier way to do this...

Hi everyone, I got three columns for my spreadsheet. column A is date in format of dd/mm/yyyy column B is Customer name column C is total sale for each customer. I set up a userform to check total of sale for a customer from a certain date. for example I want to know how many items have been...

Hi All, Part of my code isn't working. I need to filter the data to a date specified by the user. Sub Pomotions() Dim Lastrow as Integer Dim Daterange As Date lastrow = Columns("A:A").Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row Daterange = InputBox("Please enter...

Hi, I need help with my spreadsheet. We are trying to create something that allows the person to enter a date range, for example, Aug 1, 2017 and Aug 30, 2017 in another cell and all the calls with their details that have taken place between those dates (including both dates) should come up. ​...

Hi, I've been trying to look around for anything similar, but I cant find anything at all I have a list of ranged dates and a value next to them then a date for every date I want to check if it falls between any of the ranged dates and to sum every value where it does This is an example of...

My data looks like this: I wanted to sum a range that match 3 conditions 1. Country 2. Sum data from DateRange >= Day1 and 3.DateRange <= Day2 Example: I like to sum a range from 27-7 to 29-7 that match SG Tried index match for only one date and it worked, but for date range the...

I have a UDF called CountPeriod which is a glorified version of CountIf. The workbook is used to tally student attendance. There is one tab per month with a linear calendar at the top of the page. To the Right, I need to tally the absences and tardies for each student based on which of 3...

Some code; Private Sub DateReminder() Dim LastRow As Long Dim yesterdaysDate As Date Dim AlertDate As Date Dim dateRange As Range Dim foundDate As Range Dim firstName As String Dim lastName As String Dim phoneNumber As String Dim eMail As String AlertDate = DateSerial(Year(Date), Month(Date)...

I'm making a workbook to track student attendance for the year. There is an identical tab for each month of the year which has a linear calendar that will change depending on the year chosen. At the end of the month I tally the number of Absences, etc for a given term. The terms begin and end...

Hello, I am working on a records document that will be added to over time and will need to generate automatic reports. I've simplified the format for what questions I need answered, but see below the basic information 'category', 'units' & 'date': What I need to report is the total units by...

<tbody> A B 400 13/3/15 200 20/3/15 180 310 29/4/15 750 21/3/15 384 15/3/15 900 </tbody> The above is an example of my current problem. I'm trying to arrange for a SumIf formula to calculate the value of Column A within a specific date range (i.e. how many sales from A to be...

I couldn't think of a simpler way to title this :eeek: Here's my issue - I've got a table of expenses from the year, I want to get the final balance for the month from the balance column for each month. I've already created a reference cell for the first and last days of the month for something...

Hello, I am writing a macro to generate a pie chart from a growing database. I have written the below code to move all of the data entries from a specific month from the large database to another sheet to facilitate generating the chart. My problem: In the userform I'm using to find and move...

Hullo: Whilst I am a new registrant here, i have frequently spotted Mr Excel queries and responses in my many Google searches. I wonder if anyone can help me out with this one. I am running Excel 2010 (and 2013 but 2010 is fine); I have a "Data" worksheet which is essentially a raw import of...

Hi, I have a table that contains a date range when people arrive and depart certain properties.. I need to figure out how many days of each given date range (row), is in Q1, A2, etc. For example, if the date range is 6/29 - 7/4, then based on the 4qtr's starting 1/1, 4/1, 7/1, and 10/1, we would...

I have a sheet with information of college applicants. I am trying to create a sumproduct of a certain degree program that has been applied to within a certain weeklong date range. The idea is that I can submit a report every monday with the new amount of applicants from the prior week. This...