View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default I'm trying to count sick and vacation days

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