Hello all!
I have two worksheets with partially overlapping data and I need to get a number of dates, that fall between two dates when certain criteria is met:
Sheet 1:
Sheet 2:
What I'm trying to do is:
- match a combination of cells in the first sheet, for example Red&Tree, with the same combination in the second sheet (not visible in the example, but available in the real document)
- then check what number of dates on the same row in Sheet 2 (from columns C:G) fall between Date 1 and Date 2 in Sheet 1.
I'm able to cover separately the matching of cells and number of dates calculation, but I can't combine these two criteria together.
Do you have any ideas how to solve this?
I have two worksheets with partially overlapping data and I need to get a number of dates, that fall between two dates when certain criteria is met:
Sheet 1:

Sheet 2:

What I'm trying to do is:
- match a combination of cells in the first sheet, for example Red&Tree, with the same combination in the second sheet (not visible in the example, but available in the real document)
- then check what number of dates on the same row in Sheet 2 (from columns C:G) fall between Date 1 and Date 2 in Sheet 1.
I'm able to cover separately the matching of cells and number of dates calculation, but I can't combine these two criteria together.
Do you have any ideas how to solve this?