Forum Discussion

mollysnuffy's avatar
mollysnuffy
Copper Contributor
Aug 30, 2023

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 and its only giving me one ID number.

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

Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 30, 2023

    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.

Resources