| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vacation formula and 1/2 days
Hello
I have an attendance tracking workbook. one of the formulas is =COUNTIF($I6:$BU6, "V") V stands for vacation day. Sometimes an employee takes ½ a day. E.g. If an employees has taken 5.5 vacation days with the formula above the total count is 6, incorrect by ½ day. I want to use V1 to indicate ½ day taken, What is the correct formula so that I get 5.5 days. Thank in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vacation Accrual Formula Need Help Please! | Excel Worksheet Functions | |||
| I'm trying to count sick and vacation days | Excel Worksheet Functions | |||
| Keeping track of Sickdays, Vacation days, and hours for each. | Excel Worksheet Functions | |||
| How do I track vacation days on Excel? | Setting up and Configuration of Excel | |||
| Vacation Accrual Formula | Excel Worksheet Functions | |||
Threaded Mode
