| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"formula for tracking days off "
I want to track employees attendance. Employees are taking days off as half
days. The current formula I'm using is CountIf ("=COUNTIF($CS6:$GD6, "V"). How can I count half days using this functions. V represent 1 vacation day, How do I represent V as half vacation day? Please advise... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No. of days split into periods | Excel Discussion (Misc queries) | |||
| Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
| Vacation Accrual Formula | Excel Worksheet Functions | |||
Threaded Mode
