"T. Valko" wrote:
You are way over your head.
Don't trust yourself to do this right.

You have to start somewhere! <g

Yes, but not with payroll -- unless it is a classroom situation.

You are trying to be cute, I know. But this is a serious matter. In the
US, at least -- and note that the OP did indicate the country -- payroll
management involves a fiduciary duty. Failure to carry out that duty can
result in serious civil, if not criminal, prosecution and litigation, or at
least it will have financial consequences (e.g. IRS penalties and interest).

For all we know, the OP is a professional bookkeeper or account who
understands that fiduciary duty. But I hope you agree that the nature of the
OP's question reflects that the OP is totally clueless about Excel -- "a"
formula to update payroll weekly?!

If the OP "has to start somewhere", it should probably be a beginner's class
in Excel, not crafting a payroll spreadsheet.

Just my opinion.


----- original posting -----

"T. Valko" wrote:
You are way over your head.
Don't trust yourself to do this right.

You have to start somewhere! <g

--
Biff
Microsoft Excel MVP


" wrote
in message ...
"torit" wrote:
I am not familiar with Excel and need to know how
to set up a payroll spreadsheet that uses a formula
to update payroll weekly

If you are "not familiar with Excel" -- and your question reflects
complete
lack of knowledge about it (asking for "a" formula) -- you should get
professional help. I mean from an Excel programmer :-). Actually, a
professional bookkeeper or accountant who knows Excel.

I would not rely on any template. Payroll maintenance is affected by a
lot
of state law as well as federal law. No template can possibly handle the
varied law for all states. And I would even be suspicious of the
correctness
in handling federal law correctly.

You are way over your head. Don't trust yourself to do this right.