u/Duhfishman47

I have a sheet that has random dates within cells c1:c60. Some cells have a date (example 05/15/2026) whereas others are completely blank.

I need a formula that will automatically update a percentage of how many cells have “data” within the cell vs. those that do not.

Example, if I had 50 dates within these 60 total cells, the percentage TOTAL at the bottom should say “83.3%”. Once I add an additional date within these cells, it should now reflect “85%”. So on and so forth.

I don’t need it to read the date at all. Just if these “something” within the cell it recognizes it as “done”.

Hope I made sense. Thank you