Excel Expert to quickly count new customers vs renewals

I need someone who is an expert in Expert to quickly count the number of renewals vs new customers. I will provide daily data and customer IDs and the freelancer should use create a summary table containing the number of renewals and new customers each month from 2019 to 2021. For an advanced Excel user, this task should be a prompt one.