If cell contains date then add to overall percentage

[thomasheen]

Hi

I have a table below with 6 cells that when populated will contain a date that work was completed. I would like to add a percentage at the end to show progress for that row e.g if all cells contain a date then the percentage would show 100%, if 3 cells it would show 50%

Thanks

[davsth]

a samle would be easier but is the cells are blank when not completed

count(your range)/6 format as %

eg

=count(a1:a6)/6