completion percentage

Hi Experts

Your support and advice are highly appreciated, I want to represent completion percentage to track the daily tasks (monthly, quarterly ) for whole 2023 year in chart and table

For Completion sheet as mentioned above
For SLA sheet there is one condition if meet or better the target how we can calculate as above
What is the best way to do that?


Note : every week i keep add new date till end of year

at the end will be like the below

test111.JPG