Index and Match between two dates

Copper Contributor

I run several holiday lets and need to keep a count on laundry that is taken off the beds at each clean.

 

I have managed to get it to return ID no 35 on 25/08/23 but there was two cleans this day and its only giving me one ID number.

mollysnuffy_0-1693412939111.png

This information is being pulled from a full list of every linen change.
I also want it to search for a whole week so between the two dates from Fri to Thur 25/08/23 to 31/08/23. Can any one help as I've never used this function before and my excel is a little rusty.
Thank you

1 Reply

@mollysnuffy 

Do you have Microsoft 365 or Office 2021? If so, you can use the FILTER function:

 

=FILTER('Cov-War Laundry'!A5:K1000, 'Cov-War Laundry'!E5:E1000=C1, "")

 

Or for a week:

 

=FILTER('Cov-War Laundry'!A5:K1000, ('Cov-War Laundry'!E5:E1000>=C1)*('Cov-War Laundry'!E5:E1000<=C2), "")

 

Adjust the ranges if necessary.