Forum Discussion
Solved
Return cells that fall within a specified date range
I'm trying to extract income and expenses between two dates from a single column, then populate separate income and expense columns, removing all empty cells. I'd like to avoid using macros or pivot ...
I have no idea where the $130 and $563 come from, but take a look at the attached sample workbook. It uses the FILTER function, available in Excel in Microsoft 365, Office 2021 and Excel Online.
I have no idea where the $130 and $563 come from, but take a look at the attached sample workbook. It uses the FILTER function, available in Excel in Microsoft 365, Office 2021 and Excel Online.
I had never heard of the Filter() function, thank you! It worked like a charm.
Regarding the $130 and $563- they were errors I made transcribing the data into this table. Thank you for coping with my mistakes and delivering a perfect solution!
Regarding the $130 and $563- they were errors I made transcribing the data into this table. Thank you for coping with my mistakes and delivering a perfect solution!