Budgeting speadsheet

[xandreu]

I'm a newbie to Excel but normally quite good with basic stuff however my mind is blank on this one.

I want Excel to automatically list all of the outgoings I have left until I'm paid next. The trouble is I'm paid on the 21st of each month.

So I have 'the database' of my outgoings consisting of three columns, the day of the month it comes out my account, the description (company etc) and the amount.

I want Excel to take today's date and using the database, list the outgoings I have left until the next 21st. So if today's date is the 28th for example, it will only list outgoings between 29th of this month to the 21st of next month. Or if today's date is the 5th, only list the outgoings between the 6th and the 21st of the same month.

If that makes sense?

Any help, greatly appreciated.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic