• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highest consecutive year wage averages

doit2010

New Member
My retirement is baised on my highest 5 consecutive years, I am paid every two weeks and my pay changes greatly each pay period, I know what the state has caculated to date, but I would like to add each new pay check and watch how it changes going forward. I will input 26 payments per year for 5 years and then each pay check will be added to see how it changes with each addtion and deletion. I guess the average would be baised on 130 figures and adding the current paycheck and dropping the first one so that it is alway 130 paychecks used. I know nothing about excel and would like a formual to track these figures.
 
Doit2010

I will assume your pays are in cells B2:B131 and. You will add new data below this

In C131 type =average(b2:b131)

Every time you enter a new pay check copy the last cell in column C down

Excel will adjust the formula accordingly
 
Back
Top