Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Our yearly timesheets are divided into bi-weekly worksheets, displaying the
whole year. How do I formulate a running total for sick and vacation days? Example: In January, we should start out with 5 sick days and 10 vacation days, if someone takes a sick day in Feb. I want the running total to show 4. When the number reaches 0, is there also a way in which to not allow an employee to input for another sick day? -- Thanks, Holly |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You will need to specify more how you identify SICK.
Is it selected from a drop down list? Or just typed in a cell? Corey.... "Holly" wrote in message ... Our yearly timesheets are divided into bi-weekly worksheets, displaying the whole year. How do I formulate a running total for sick and vacation days? Example: In January, we should start out with 5 sick days and 10 vacation days, if someone takes a sick day in Feb. I want the running total to show 4. When the number reaches 0, is there also a way in which to not allow an employee to input for another sick day? -- Thanks, Holly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|