Macro that concatenates two cells, references a Date and then copy pastes value into first

Deleted 

I'm glad you managed. I would like to clarify the point that a Pivot Table is useful not for doing what you've been doing--which (if I understand it) is actually creating the expense records at a granular (by transaction) level. But the Pivot Table is for the purpose of summarizing expenses (or whatever the database happens to be) in a cross-tabulated way. So in mine, for example, all payments for groceries are summarized by month, each month showing a single total for groceries. Same for expenses for gas, car repair and maintenance. The database contains all the details; the pivot table takes those details and shows patterns over time, or patterns by category. Things like streaming audio and streaming video and other mainly discretionary expenses are sub-totaled as Discretionary, even while summarized by those more specific categories.

I create my database by downloading the details of checks written, bills paid, credit card transactions from the various financial institutions. Those all comprise the database. There are thousands of rows of data in a year. The pivot table creates manageable, intelligible summaries.

just finished the entire expense section..current month's bills, next month's and a custom date range...

managed to get it done without a macro or pivot table..just formulas...very happy with it.

much more aesthetically pleasing in my view