How do I get year to date earnings on a payroll spreadsheet(what'.

I am trying to create a payroll spreadsheet. I want to get the formula for
year to date.
I would rather not use a 52 column sheet with totals. How can I add the
change each week without using a large sheet?

If I can offer an opinion: regarding payroll, keep as much information
as you can. Payroll is sacred- people literally live by it, and they
are VERY concerned that proper records are kept. A Fortune 500 company
is judged by its stock price; small and even medium sized companies are
judged by whether or not they met payroll.

My suggestion is to allow the spreadsheet to be as large as it needs to
be in order to keep highly detailed, accurate records. The LAST thing
you want is to be forced into a corner, where you have to say to a
state examiner of one type or another "I don't know what the payroll
data is for week x" just because the spreadsheet isn't a few columns
wider. When the sprdsht gets wide, just hide the earlier columns.

Keep the data- protect yourself and your company.

Pontification ends!

Thanks I appreciate the information

"Landon C" wrote:

I am trying to create a payroll spreadsheet. I want to get the formula for
year to date.
I would rather not use a 52 column sheet with totals. How can I add the
change each week without using a large sheet?

Thanks Dave for the reminder.

"Dave O" wrote:

If I can offer an opinion: regarding payroll, keep as much information
as you can. Payroll is sacred- people literally live by it, and they
are VERY concerned that proper records are kept. A Fortune 500 company
is judged by its stock price; small and even medium sized companies are
judged by whether or not they met payroll.

My suggestion is to allow the spreadsheet to be as large as it needs to
be in order to keep highly detailed, accurate records. The LAST thing
you want is to be forced into a corner, where you have to say to a
state examiner of one type or another "I don't know what the payroll
data is for week x" just because the spreadsheet isn't a few columns
wider. When the sprdsht gets wide, just hide the earlier columns.

Keep the data- protect yourself and your company.

Pontification ends!