Comparing registration numbers YoY

Using excel to track registration for an event. I’d like to be able to compare how many people have registered X days to event vs last year at X days to event.

Both files have a column for the date someone registered.

I’d like a formula that compares how many people have registered in 2026 vs this time 2025.

Thinking of a v-lookup but also have to factor in the date.

Any help would be greatly appreciated!!!