Macro to count total of on a weekly basis

[Profi10]

Hi everyone,

does anyone have a macro to automatically count all completed tasks on Sheet 1 on a weekly basis and display the figure in a report on Sheet 2 or at least a macro that can do it based on the weekly date range and I can then update that range weekly. Example below: On sheet 2 display figure that 3 projects were completed in the week 14/2-20/2

Thanks
D

Task	Status	Completion date
Project 1	In progress
Project 2	Completed	15/02/2022
Project 3	On Hold
Project 4	Completed	18/02/2022
Project 5	Completed	14/02/2022

 

[Profi10]

Doesn't have to be a macro, formula would be good as well