date range

Hello, I am trying to replicate standard excel functionality using cube functions. I have employee transactional data. This data contains a unique ID, an effective date, and an employee status - active or term. The data is sorted by empl id and effective date, both ascending. From this...

Hi, I am making a project plan/financial model in Excel (don't have access to MS Project) and one aspect of it is I have to be able to show how many of a certain type (i.e. Res1, Res2 in attached picture) of full-time employee (FTE) will be needed for a given month. Each "Major Activity"...

I am having trouble figuring this out. I have a SELECT DISTINCT query, which is working fine. In the table that the query is based on, there is a Date Column. I would like to add BETWEEN DATE RANGE criteria to this query, but I have been unable to do so. If I add the date column to the query...

Hi, I was trying how to find accumulated sales based on booking date column in excel. Appreciate your quick help. I have different sheets with flat numbers and booking date columns. Each sheet indicates each block. As a summary I would like to create another sheet where in I want to show no...

I am trying to conditionally format cells so that if the date is within the range 01/07/15 - 31/06/16 that it will be highlighted red, is this possible? I cant seem to figure it out!

Hi, First, sorry for my limited English. Say I have two sheets: the first one "Price control" with a list of products and their prices at different dates the second one "Sales" with a list of sales at different dates In the sheet 2, I need to get the price of each product at a given date...

I am doing a royalty statement where is the sale occurred on or after 01/01/14 the manager would get 15% commission and if the sale was after 01/01/14 then they would be 15% commission. I have been provided a spreadsheet that has the sales date as a range ( ex. "0110-0613"). I have tried using...

I have a pivot table (derived from PowerPivot) that displays data filtered by a Timeline Slicer. The Pivot table is then represented in a Pie Chart which has a title. Is there any way I can link the title to the Timeline Slicer range, so it indicates the date range for which the pie chart is...

Hi and thanks to all in advance I am trying to create a formula to calculate the $ total of my employees work via a few variables. At present I have a working formula that calculates each individual employees $ total; =SUMPRODUCT((C1:C24999=service type)*(V1:V$24999=Practitioner...

I am trying to create a spreadsheet which contains a list of bills, such as Gas, Electric, telephone etc., each of which is payable on a set day each month. The spreadsheet lists these bills in the first column, and then has a column for each week of the year, with Monday as the first day of the...

Table 1 https://drive.google.com/file/d/0Bx7mqy8e5hoXZDFiT2ZuWlh1YnM/view?usp=sharing Table 2 https://drive.google.com/file/d/0Bx7mqy8e5hoXa3VHMlBHWWJ4cDA/view?usp=sharing Ok. So what I want to do is to type a date range into column C on Table 2 and then have it auto populate the total bills...

I need a formula that will lookup a value based on two criteria, one just a cell reference, the other if the period falls within a given range. I was thinking this could be done using a Index>Match formula, but the date range is throwing me off. I'm hoping this can be accomplished without an...

Hi, I have two tables: 1) Tbl1 is a user input table and 2) Tbl2 is a pivot table of sales data by Cust_ID and YearMonth. Below is just a sample data, but you can imagine the pivot table can get quite large due to the number customers and YearMonths. Instead of manually updating the pivot...

Hi All, I have a problem, the task is to be able to count the amount of unique users logged onto a system within a variable date range (To be changed by the user accessing the spreadsheet) I have all the data in a spreadsheet currently and am able to get the count of unique users by using the...

I am having trouble averaging the price of a specific product for a specific date range. Attached is a sample of the excel sheet I'm working with. Of course, the sheet is much bigger but I feel that simplicity will help find the best solution. I use a 4 letter tag number to identify the...

Hello Everybody, this is my first post, so don't be to harsh on me :-) Need you help with the following spreadsheet: Column A: Name of supplier (A, B, C) Column B: Product Description (X, Y, Z) Column C: Price Column D: Date when the quote was received. Data goes like: A X price date A...

Hi Good morning all, I have a fSa*****ok with columns OrderDate, Products, Delivery Date, ShippedDate. While DeliveryDate is a promised date to deliver an item, ShippedDate is the date the item got delivered actually. Sometimes items can be shipped a bit earlier or later, sometimes both...

Hi, I've been scouring the internet to find a solution to my problem but I haven't found one yet. I'm looking to increase a cell by 4% each day between a set date range (workdays would be preferable). I've tried formulas using TODAY() and NETWORKDAYS, but I can't seem to get my head around...

I am trying to determine and track my commission within specific date ranges. Example: If I sell a job today for $10,000, I will get paid 5% commission on the next paycheck, and then when the job is complete and paid, I will get another 5% commission. I would like to make both of those separate...

Hi, I am looking for a formula to accomplish this on a large spreadsheet: If B2 is less than 12/31/2012 but greater than 12/31/2011, then return the year 2012 The complicated part is I need this for years 2009, 2010, 2011, 2012, 2013, and 2014 all in one cell? Thank you so much for your help.