How to get a percentage of completion on a daily basis, week by week

I am not sure whether the title is the correct one. My scenario is this. I am supposed to provide a summary of my daily progress , week by week for 4 weeks.This is for an onboarding training. Each day there are certain tasks I have to complete. The number of tasks can be different for each day. This can also change in between too.

I created a summary tab and a schedule tab and listed tasks. Column A of Schedule tab gives the Week numbers, like 1-4, and Column B gives the day of the week, like 1 to 5.The tasks are listed in Column C. The number of tasks can increase or decrease (is dynamic). Now based on the Completed status (Indicated by Y) in Column E, I should be able to provide my percentage of completion on each day in the summary tab .

Could you please provide me a solution,

Thanks in advance,

Jans

Hi There,

I have worked something and attached for your reference. I think this should help you or if not do let me know, will take a look again.

Thanks

Vishnu