Percentage of filled in boxes in a column formula

[fireman175]

Hi, I have a few columns with about 150 rows broken into say 5 sections (30
rows each). I enter a date in each box as a procedure is completed. I would
like to keep a tally of the percentage of completion for each column. So,
each time I enter a date in the 150 rows, the percentage of filled in boxes
increases.

Thank you in advance.

 

[Max]

Since real dates are numbers, something simple like this,
placed in say E1: =COUNT(A1:A30)/30
with E1 formatted as percentage to taste
should yield what you're after

Adapt/extend to suit

 

[fireman175]

I tried that, but it just gave me date of 1/0/0. Any other ideas?

 

[Max]

I tried that, but it just gave me date of 1/0/0. Any other ideas

No reason why it should not work. As mentioned in my response, I presumed
you are entering *real* dates within A1:A30. What is displayed when you
format that formula cell as percentage (under Format>Cells)? 0%?

 

[fireman175]

Ahhh, that was the missing link. I changed that cell to percentage and it
works great. Thanks alot for your knowledge. I learn alot from people like
you helping us out.

 

[Max]

No prob, you're welcome. Pl take a moment to press the "Yes" button below.