Lookup dates between two dates from a dynamic master date column

[iamafreak]

Hello Everyone,

I am struggling to find a formula that is flexible enough to fit my needs.

I have a source sheet where I have a list of dates that is refreshed every month. The dates are starting in cell B14 onwards and going down to B79. It has dates from 29.12.2017 to 30.03.2018. Next month the dates will be refreshed to 30.04.2018 and so on.

I have another summary sheet where I enter Start and End dates in cell B4 and B5 respectively. In the same sheet I have a table where I need to display dates from my source sheet that are greater than or equal to B4 and less than or equal to B5

For instance, I have entered 31.01.2018 in B4 and 28.02.2018 in B5

I need a formula in J3, which looks up dates in my source sheet column B and insert 31.01.2018 in J3, 01.02.2018 in J4, 02.02.2018 in J5 and so on till 28.02.2018 in J23. If I drag the formula down to J24, then it should be left blank as it out of my look up range (31.01.2018 to 28.02.2018)

any help is much appreciated
Thanks

 

[iamafreak]

Sorry to bump