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.