Thread: I'm trying to count sick and vacation days
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default I'm trying to count sick and vacation days
=COUNTA(A1:A100)-COUNTIF(A1:A100,"~*")/2


"Kevin" wrote:

I specify 1/2 days as a date with an asterisk.

"Bernard Liengme" wrote:

And how are 1/2 days specified in your data?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kevin" wrote in message
...
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?



Reply With QuoteReply With Quote