How do I input daily calculations for employee tracking and have it calculate weekly and monthly
Posted by Sheri on January 08, 2002 9:34 AM
Hi,I'm creating a workbook to track call center employees calls, apps taken, funds complete, etc. I need to track this on a daily, weekly, monthly and yearly basis. I would like to set it up so I can input the information daily on one sheet and have it calculate weekly, monthly and yearly per employee. How can I set up these formulas without making a page for every employee, every day, every week, every month? I know there must be a way that I can input the data daily and have it calculate weekly and monthly with out having to save all the days calculations for the formula reference. Thanks for any help you can give me!