Forum Discussion
mollysnuffy
Aug 30, 2023Copper Contributor
Index and Match between two dates
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 ...
HansVogelaar
Aug 30, 2023MVP
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.