How to return dates that fall within a year

I have a sheet [Sheet1] which contains location and dates

Column A contains locations and Columns B to BT contains dates which ranges from years 2013 to 2023

Sheet1

	A	B	C	D	~	BT
1	Loc1	(date)	(date)	(date)		(date)
2	Loc2	(date)	(date)	(date)		(date)
3	Loc3	(date)	(date)	(date)		(date)
~
46	Loc46	(date)	(date)	(date)		(date)

I need Sheet2 to summarize Sheet1 for this year (2017)

Column A, still have locations and on Columns B and C return the dates which fall within this year 2017

Sheet2

	A	B	C
1	Loc1	(date)	(date)
2	Loc2	(date)	(date)
3	Loc3	(date)	(date)
~
46	Loc46	(date)	(date)

There are just mostly two dates in each row that fall within the same year

I need to summarize until 2023 on different sheets

The dates may change from time to time so I can't copy paste to summarize

I have tried index and match but I don't know how to address dates

Thank you in advance

deleted.....

Hello leruma. Welcome to the forum.

I took a guess.

With random dates in sheet1 array enter this formula in Sheet2 cell B2. Fill down and across until you get blanks.

Formula:

Please Login or Register  to view this content.

See the attached.

Good deal. Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.