Formula to subtract pay periods each payday

[Robert Wyatt]

I'm retired and have to watch my yearly income due to I can't go over 21,240.00 a year or they will take 3.00 dollars for every dollar I'm over from my social security check. Is there a formula in Excel that I can use that will subtract pay periods from the remainder of periods to go? I get paid bi-weekly that is 26 pay periods for the year. Right now I have it fixed up as if I was doing payroll year to date. but not sure it will be the same. I need it to subtract each pay period from 21,240.00 so I can keep track of how much I have left before going over the yearly limit.

 

[Robert Wyatt]

Yes, that worked thanks again for your help.

 

[Sufiyan97]

You're welcome!