rolling

I'm trying to help my manager create a spreadsheet to track various types of absences and leave. I've linked the spreadsheet here to see what I have set up, but need to figure out how to extract the right data. I am looking for a way to figure out absences based on a rolling calendar year, and...

I have a table that is filtered by monday dates to pick up the current monday date and the previous 10 mondays to create a rolling summary. I am wondering is there any way I can setup a dynamic filter so it always picks up the previous 10 weeks each monday rather than manually removing one date...

Hi All, I have numerical data in over 1000 cells in ColumnA, and I am in need of finding the highest average from a rolling average of 10 consecutive cells. Can anyone help? Thanks in advance Pedro

Hi, I am trying to do a running total based on Date and Hours. The end result that I want (table A) is the "rolling hours" column. Table A DATE Person Hours Rolling Hours Tue, 05/28/19 Peter Pan 12.06 12.06 Wed, 05/29/19 Peter Pan 4.97 17.03 Sat, 06/01/19 Peter Pan 12.10...

I have a formula, found elsewhere, that counts the totals of cells from current date – backwards for one year =SUMIFS($L$5:$BDQ$5,$L$3:$BDQ$3,"<="&F37,$L$3:$BDQ$3,">="&DATE(YEAR(F37)-1,MONTH(F37),DAY(F37))) Data in $L$5:$BDQ$5 Dates in ,$L$3:$BDQ$3 Todays date in $F$37 This works perfect for...

I have a data set that I am trying to calculate a moving average. In the below Data set is the date started, date ended, and value is the simply the number of days between those dates. The moving average I am trying get is a rolling 12 month average shown on a monthly basis. See column of 12...

I have a data set that I am trying to calculate a moving average. In the attached picture the Data set is the date started, date ended, and column C is the simply the number of days between those dates. The moving average I am trying get is a rolling 12 month average of Column C shown on a...

Here's a weird one. Due to the sheer laziness of some team members, they want to enter "1730" into a cell and have it convert to "17:30" Likewise, "530" would convert to "05:30" (5:30AM) I'm literally rolling my eyes because they can't be bothered to just physically write "05:30" (and yes...

I have a price point available with me from 1979 to 2018. I am looking to calculate the rolling return of this years for 1/2/3/5 Years period. Also, This returns I am looking in Percentage terms. Please advice right method

this may be more of a math question but in column A i have a rolling 12 month balance column B is a basis points assigned to a product Column C is the "new value" example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the...

Hi. I'm after some help with adding a formula to calculate a rolling average of the last 10 entries of a certain criteria. In column A I have five different locations. There are multiple entries for each location in the date order of measurements taken and column L has a measurement taken at...

Hi all, I have looked online but can't seem to find an answer to this. I have currently filtered the date by specific year which looks like below. What I am trying to do is use a slicer so that I can choose between dates and also get a text return linked in but I cannot seem to figure out how...

Problem Statement: Column B through D track a rolling count of items that are open and closed for a duration of the last 30 days based on today's date. (Blue table) I'm trying to accomplish the same function by using rolling weeks instead. (Yellow Table) This is simple, but I've been at this...

Hi everyone,I am trying to create a spread sheet that adds up my staff's hours worked for a rolling 119 day period, sounds easy but I have to ignore any day that they have taken as leave but still include a 119 day period. For example if I had a member of staff who took 6 days off in that 119...

Hi All, My husband has an 8 week rolling rota and I'd like to create a spreadsheet where he can enter in the year and it will automatically fill the dates he's working and off. There are actually 8 teams, each with a different 8 week rolling rota so it would be good for a drop down to show the...

Hello Friends, I need some help finding a DAX solution to a solved Excel problem in the link below. https://1drv.ms/x/s!AuhgWIfRbRU2oXSl2z7NPx8Q9YjR Essentially I need a rolling sum that calculates a row count for all rows that exist within 1 hour of the original time. (Ideally, being able to...

What I was asked to do is to create a countdown timer that starts with the first value in a predetermined list of roundtrip times, and when it reaches zero, it has to move on to the next value and so on, till the list has been completed and then stop. This list with time values will eventually...

What I was asked to do is to create a countdown timer that starts with the first value in a predetermined list of roundtrip times, and when it reaches zero, it has to move on to the next value and so on, till the list has been completed and then stop. This list with time values will eventually...

I am currently using a pivot table which shows information regarding how much time an employee has worked, which is separated by week number. I would ideally like a GETPIVOTDATA formula to take this information and place it onto a dashboard screen, however only show the data from the past 5...

I am trying to calculate a rolling 12 month average. The hard part is I need to keep a column ("Total" column). I am not sure the easiest way around this. I'm assuming OFFSET can be used, but am looking for ideas. TIA <tbody> May 2017 Jun Jul Aug Sep Oct Nov Dec Total Jan 2018 Feb Mar Apr 1...