Use the COUNTIF function, count up your half days, multiply the number
by 0.5, add this to the result of a second COUNTIF function.

=COUNTIF(A2:A50,0.5)*0.5+COUNTIF(A2:A50,1)

Hope this helps,

David

On Jan 24, 10:43 pm, Kevin wrote:
.5 is how I designate half days, the count formula only returns a whole
number, namely 1.



"Dave F" wrote:
How do you designate 1/2 days? Just count those and add that count to your
original count....
--
Brevity is the soul of wit.

"Kevin" wrote:

I've used the count formula to count the number of dates entered in a column,
but how do I account for 1/2 days? Any suggestions? Maybe another formula?- Hide quoted text -- Show quoted text -