Forum Discussion
niksirat
Aug 30, 2022Copper Contributor
show automatically rows of created data between two dates
I created a sample Form with data in the DATA sheet. How can I write a code that displays automatically (without press Enter or etc), the rows of existing data in DATA sheet whose date of birth i...
DexterG_III
Aug 30, 2022Iron Contributor
niksirat With Excel 365 you can use the following formula.
=SORT(FILTER(Table2,(Table2[Date]>$B$1)*(Table2[Date]<$B$2)),2)