So I'm trying to do three things that are related to each other that I'm struggling to figure out:
I'd like to filter an entire column (B) based on a the month (let's say April), while maintaining the format of month/day/year. Is this possible?
Once I accomplish the above, I would like to be able to display subtotals based off of this filtering in my yellow (J26) and green (K26) cells. So if the filtering is done right, the J26, and K26 boxes should display subtotals for the month of April.
Then (I know I'm being a bit ambitious) I also want a complete separate sheet to reference subtotals for the month of April to help me estimate cash flow. Not sure if this is possible or not.