How to pinpoint specific date from limiting ranges

Hello narbit and welcome to the forum!

Consider listing down all years beginning 1900 (say) to 2025 (say) in Column A.

List your events with start year and end year in 3 columns.
Column C - Event name
Column D - Start year
Column E - End year

In Column B against each year you could then find out the common period between these time ranges using an array formula.
=IF(AND(A2>=StartDates,A2<=EndDates),A2,"") copied won
Confirmed with Ctrl+Shift+Enter and not just Enter

Note the defined name ranges to capture the StartDates and EndDates.

Is this something you can work off?