Search code examples
dategoogle-sheetsfiltermaxmin

Values between a date Google sheets


I have a more than 10k rows with date time values and would like to filter them by date.

Like the example below enter image description here


Solution

  • use:

    =FILTER(A:A; INT(A:A)=C2)
    

    min:

    =MIN(FILTER(A:A; INT(A:A)=C2))
    

    max:

    =MAX(FILTER(A:A; INT(A:A)=C2))