Excel: How to select a cell based on current month
November 23, 2007 9:40 AM Subscribe
Excel Filter: Selecting a cell/row based on current month.
I'm putting together a payment spreadsheet for a very small business, and I'm piecing it together slowly. I'm sure there are easier/elegant solutions abound, but this is what I have so far.
In this example file:
(Screenshot if you can just work from that)
I have a column of dates and a column of current balance (Starting at A9 and B9). I want the Total Unit Due in cell C5 to look to the current month's balance.
I've played around with a formula to compare the current month to the month from column A*, and that works just fine. What I can't figure out is how to make it select the appropriate row.
Sorry if this isn't overly clear, I'll try to clarify as needed. (Microsoft Excel 2007)