I'm trying to count sick and vacation days
 

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?

I'm trying to count sick and vacation days
 

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?

I'm trying to count sick and vacation days
 

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?

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?

I'm trying to count sick and vacation days
 

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?

I'm trying to count sick and vacation days
 

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 -

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?