"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...

"formula for tracking days off "
 

Why not just divide by 2 / multiply by 0.5, eg:
=0.5*COUNTIF($CS6:$GD6, "V")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mcwsrexcel" wrote in message
...
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...