How to search two column ranges of dates that occur in specific month and year

 

Is there a formula to check which cells occur within a specific month and year?

 

Start

end

Mon, 23/08/2019

Tue, 24/08/2019

Mon, 15/01/2018

Mon, 29/01/2018

Wed, 06/12/2017

Thu, 07/12/2017

Mon, 15/07/2019

Mon, 15/07/2019

Mon, 24/06/2019

Mon, 24/06/2019

Tue, 18/06/2019

Wed, 19/06/2019

Fri, 07/06/2019

Fri, 07/06/2019

Mon, 15/04/2019

Wed, 24/04/2019

Fri, 29/03/2019

Fri, 29/03/2019

Mon, 23/11/2015

Mon, 23/11/2015

Tue, 03/11/2015

Tue, 03/11/2015

Tue, 27/10/2015

Tue, 27/10/2015

Mon, 03/06/2019

Mon, 17/06/2019

Mon, 15/04/2019

Wed, 17/04/2019

Wed, 27/03/2019

Tue, 02/04/2019

eg: I am searching for cells that occur in December 2017 within either of two columns represented as start and end date.

 

 

 

By: Daniela

Leave a Reply

Your email address will not be published. Required fields are marked *