"formula for tracking days off "

[mcwsrexcel]

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

[Max]

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" <[email protected]> wrote in message
news:[email protected]...
> 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...