If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2 Que's regarding dates (matching and subtracting) | jacob farino | General Discussion | 1 | October 11th, 2004 05:11 AM |
Obtaining a Year value from date | ChuckW | Running & Setting Up Queries | 2 | August 20th, 2004 02:47 AM |
Year when date falls on specific weekday | kimberf | Worksheet Functions | 4 | August 12th, 2004 09:49 PM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |