Formula to calculate % based on a number & text in cells

Morning all, first post here.

I have a form in work which acts as a tick sheet for tasks complete on a construction site. When a task is complete I copy & paste from a key of dates i.e. week ending 11.05.15, this allows me to see what week a task was complete.

Generally I only marked off tasks which were 100% complete but my manager wants me to enter the % of the task complete also, i.e. 80% in the box.

So my question is how can I have the formula assume that any box with a date & shading is 100% and any cell with a number i.e. 80 is only 80% complete. I need it to monitor around 150 cells and give me the overall % complete based on what i have discussed.

I realise it would be easier for you to see the database so if you email me or PM me that's fine.

Regards,
Conor

Originally Posted by nathansav

COUNTIF will be the formula to use. So it would be something like =Countif("A:A","100")/counta("A:A")

Thanks Nathan,

I will use that however can the 'countif' be set to recognise a date or 8 characters? (i.e. 11.05.14). I have attached the file in question.

Originally Posted by nathansav

Sorry i'm a bit lost now, what is it you want doing and where on the sheet?

Sorry I uploaded the wrong file! See attached.