I'm trying to link two absence spreadsheets together, each worksheet being a

separate month. I need a formula to calculate the absences on a rolling 12

month period, therefore, each time I input the current month's figures, it

adds them to the 12 month rolling total but takes one month off the beginning

of the 12 month period!

separate month. I need a formula to calculate the absences on a rolling 12

month period, therefore, each time I input the current month's figures, it

adds them to the 12 month rolling total but takes one month off the beginning

of the 12 month period!

- Formula for calculating 12 month rolling period
- 12 month rolling in excel
- Formula for calculating a rolling 12 month average in excel?
- Copy formula for the 12 month
- Formula for calculating fixed monthly accruals by prorating based on start date
- 12 Month Rolling Average Chart
- 12 Month Rolling Totals
- 12 month Rolling Total
- How do I count dates in a 12 month rolling period?
- How to count dates in a 12 month rolling period
- Formula for Calculating (Accrual) Off Time (PTO)
- Turn Dynamic Horizontal Chart into 12-month rolling
- FORMULA FOR CALCULATING MIN MAX INVENTORY LEVELS
- 12 months rolling data in graph format
- Need formula for calculating hours in timesheet
- Formula to Count 12 Months back for Finance calculation
- Counting no of days from a list of running dates for a 12 month pe
- DSUM and data collection with 12 month rolling tally
- 12 Month Rolling Average
- Rolling 12 month date filter for pivot table?
- 12month rolling total
- Formula for end of month time periods
- Calculate 12-month average based on multiple criteria
- FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE

separate month. I need a formula to calculate the absences on a rolling 12

month period, therefore, each time I input the current month's figures, it

adds them to the 12 month rolling total but takes one month off the beginning

of the 12 month period!

emissions. I believe I know the formula but need some reassuring.

Thanks.

in column b i have to write the formula for the sales result of a saleman

eg in b1 i will have his sale for january (=january!m12)

i want to copy down the 12 month so i will obtain in b2(=february!m12) in b3 (=march!m12) and so on... i did not find the way of doing this and i dont want to do it by clicking the month sheet and then the cell in wich i have the sesult

thank

I'm trying to calculate a monthly leave accrual formula for staff on a monthwise table.

In the sample file attached, John has joined on 01-NOV-2010 so his leave accrual will start from Nov @ 2.5 per month. But I would like to have a formula that returns accrual as zero for the months prior to his joining.

Similarly, Mary has joined on 15-Dec-2010 so in the joining month of Dec2010 her leave accrual will be (2.5/31 x 17 days of service in Dec) and for the following months it will be 2.5 per month

Like Ali, who joined on 17-Feb-2011 wil have the zero accruals till the month of Jan and in Feb it will be (2.5/28 x 12days of service in Feb )

I hope the sample is clear. Any remote soultions to build on will be helpful.

Thanks

I've looked at a few similar methods, but I am having a hard time getting my formula to work

I need a 12 month rolling chart that averages according to the 'start at row' box. Ex: setting it for oct-07 will average to sep-08.

I attached the file for an example. Let me know if i'm on the right track/missing anything.

Thanks!

the persons names

a total for each month i.e. days off that month

I need it to update the totals for the 12 months previous after each new month is added to the bottom of the list.

Hope thats clear, really looking for ideas how to go about this and maybe any examples.

What formula do you use to keep a 12 month rolling total of data for example:

August 2005 3.0

Sep

Oct

Nov

Dec

Jan 2006

Feb

Mar

Apr

May

Jun

Jul

Aug

September 2006 2.5

When adding the data from month to month it changes all data to the most

current so all other months will be 2.5 is there a formula I can use to stop

this from happening?

Hopeful

I have a collum in which i will be entering dates and i'm looking for a sum that will only count the dates that are within the last 12 month.

Can anyone help?

I have a collum in which i wish to enter dates. I'm looking for sum that will only count the dates that are within the last 12 months from todays date.

Can anyone help?

I need to develop a tracking spreadsheet (for 18 employees) that will calculate accruing vacation time (on one worksheet) based on the following parameters:

Employees who have worked less than 1 year with the company:

- 10 days

Employees who have worked at least 1 year with the company:

- 12 days

Employees who have worked at least 2 year with the company:

- 13 days

Employees who have worked at least 3 year with the company:

- 14 days

Employees who have worked at least 4 year with the company:

- 15 days

Employees who have worked at least 5 year+ with the company:

- each year will add 1 day until reach the max 20 days

In addition I need to be able to deduct vacation time used. Does anyone have any suggestions for layout or for a formula that can do part of these functions? I appreciate any advice!

Referenced old thread

http://www.excelforum.com/excel-char...tal-table.html

Vertical Dynamic 12-month rolling chart (w/out Vlookup solution modification)

I wonder if anyone can help with a grapfh query. I need to be able to plot 12 months rolling data on a graph, but I need to be able to refresh the data monthly and the graph to change to the next 12 months rolling data? But I don't want to have to ask the graph to change its source data every month.

thanks

Brissy

In my example (attached), you can see that the hours for 1/20 are over 8 hours, and 10 hours is showing in the "Total Regular Hours" column. I would like for all hours entered in this column to stop at 8, and any hours over 8 would show in the "Total Overtime Hours" column. (In this case, there should be an '8' in the "Total Regular Hours" column and a '2' in the "Total Overtime Hours" column.)

I've tried a few different options, but I can't figure out what the formula would be to achieve this result. Any help would be greatly appreciated!Timesheet Worksheet.xls

Here is the formula:

=(FVSCHEDULE(1,M79:M90/100)-1)*100

Thanks in advance for any assistance.

total for the last 12 months (from last day of last sick entry).

The problem I have as the ist is added to I need a function/formula to work

out 12 months from last date and then add up the no. of sick days from then

to last date.

Below is the chart

Column 1 Start date of sickness

column 2 End date

Column 3 the number of days sick in period (column 2 less column 1 in days)

column 4 the number of days sick in period above excluding week ends (column

2 less column 1 less weekends in days)

column 5 total sick days in last 12 months from date in column 2 going back

a year including weekends

column 6 total sick days in last 12 months from date in column 2 going back

a year excluding weekends

What function or formulas can I use to calculate column 3,4,5 & 6.

Im a not very experienecd in Excel so any help appreciated and make it easy

as I struggle sometimes. Thanks Bill

Is there a better way to do this?

Basically I really need to keep the 2002 data, and just add on to it with 2003 data, so that my summary will always contain a rolling 12 month chart. Does that make sense? I hope so. Any help in this matter would be appreciated.

I'm trying to create a formula that will show a twelve month average and will change as the month changes. In addition, if i were to have a cell that I can put a "6", "12", or "18" to show those monthly averages. At the same time, have a graph that will update automatically.

Currently i have a workbook set up with a worksheet that has data from 2006 through 2007 for 480 categories. I anticipate using this worksheet through 2010. I was playing on having a second worksheet that has all of the categories set up so that i may be able to see a rolling average for them. I also have an input cell (A1) so that i could put a 6, 12, or 18 in it depending on the number of months i want to see the average for.

I used the following formula =SUMIF(A3:AH3,">="&DATE(YEAR(TODAY()),MONTH(TODAY())-$A$1,1),A4:AH4) but not sure if it is what i'm looking for. Due to how my financials publsih, i almost need to be able to determine the months included, not so much from the current day/month being used in the formula. For example, i'm currently reporting on Dec. 21, 2007 numbers so if i put a "12" in cell A1, i want to see an average for the last 12 months. However, the formula i have doesn't seem to do that. Now if i put data in for all my dates (Through 2010), then it gives me an average but from Jan 07 through Dec 2010. I hope i'm making sense. Any assistance would be greatly appreciated.

Thank you.

a pivot table? I see how to add last year, last month, etc., but I need a way

to filter for last 12 months (or even last 6) so that I don't have to update

the date filter every month. This pivot table is for manufacturing production

data and is connected to an analysis services data cube.

my data set is set up similar to table below...so in D8, based on date in D6, return sum for the 12 rolling months (04/30/10-03/31/11).....can someone help with this formula? not really sure where to start...index/sumif??? thanks in advance!!!

A B C D E F G H I J K L M N O P Q R 1 Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 2 50,000 50,000 2,500 75,000 51,000 3,652 58,236 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 3 4 587,888 expected total as of 03/31/11 5 6 As of date: Mar-11 7 8 TOTAL: 9

In the next column each of the 12 cells say 1st - 15th. In the 3rd column I would like for each cell to say 16th - 31st or 16th - 30th or 16th - 28th depending on the month. Also would like it to say 16th - 29th for february on a leap year. The idea is that the user selects a month from the list and the 2nd combo box offers up 2 choices, one being 1st - 15th, and the 2nd being 16th - whatever day the last day of the month is.

example of worksheet list

column G..........column H..........Column I

Month...............1st - 15th..........16th - Last day of month

I am doing my own accounts for my business and I'm trying to set up a system which on one sheet, shows the running total of takings so far in the year, my allowable expenses, the resulting taxable profit and then the goverment deductions (tax, NI and student loan). I'd then like to have another sheet of monthly summaries, detailing the same as the above but so I can take a wage and put some money away for the tax bill at the end of the year. I'm struggling to think of a formula which brings in the tax built up so far, minus what I've already put away from previous months to give that months contribution- I'm hoping this makes even the slightest bit of sense lol.

I've based my annual summary on the threshold I'm allowed before I start paying and I'm using an IF formula- if my taxable profits are less than 7500 (not right I know but for the example) then I pay no tax, if its more, I take 7500 from my profit and it gives me 20% of that.

I basically need to know how to average this figure over the 12 month summaries. I don't know if its possible or even if my question makes any sense, but hopefully someone can help me?!

HAVE SERVED WITH OUR COMPANY. WE HAVE ONE PERSON WHO RESIGNED AND WAS

REHIRED, TWICE. BELOW IS THE FORMULA I USED FOR EMPLOYEES WHO WERE HIRED AND

ARE STILL CURRENTLY WORKING FOR THE COMPANY.

=DATEDIF(B27,C27,"Y")&"YEARS,"&DATEDIF(B27,C27,"YM ")&MONTHS,"&DATEDIF(B27,C27,"MD")&"DAYS"

PLEASE HELP ME EDIT MY FORMULA FOR THE EMPLOYEE WHO HAS COME AND GONE

SEVERAL TIMES. THESE ARE THE DATES THIS EMPLOYEE HAS SERVED WITH THE COMPANY.

02/01/88 - 05/06/88

01/15/89 - 06/15/06

02/01/99 - PRESENT

No luck finding an answer? You could always try Google.