## Bill reminder in excel

*Article updated on April 19, 2011*

Brad asks: I'm trying to use your formulas to create my own bill reminder sheet. I envision a workbook where you enter your bills due date and their frequency. However what makes mine different than yours is I'd love for it to auto populate the bills based on my pay periods. I'd want it to list the bills I have to pay with the corresponding check. In other words I dont care what date my phone bill is due, because I live hand to mouth, so their due date is actually the day I get paid, make sense? If I get paid on the 5th and then again on the 19th, the sheet should list all the bills I have between the 5th and 19th as bills I need to pay with my check on the 5th. if I have a bill due on the 18th it should still list it as to be paid from the 5th check because paying with my check on the 19th would be too late. make sense?

### Answer:

Sheet Bills

Sheet Reminder

**Array formula in cell B1:**

### How to create an array formula

- Copy (Ctrl + c) and paste (Ctrl + v) array formula into formula bar.
- Press and hold Ctrl + Shift.
- Press Enter once.
- Release all keys.

**Array formula in cell C1:**

*+ CTRL + SHIFT + ENTER*

**Array formula in cell D1:**

*+ CTRL + SHIFT + ENTER*

### Explaining array formula in cell B1

*To be continued...*

### Download excel sample file for this tutorial.

*Bill reminder
(Excel 2007 Workbook *.xlsx)*

Automate net asset value (NAV) calculation on your stock portfolio

Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]Excel udf: Import historical stock prices from yahoo – added features

This post describes how to import historical stock quotes from yahoo. This custom function is more advanced than the previous […]Calculate your stock portfolio performance with Net Asset Value based on units in excel

In a previous related post we calculated the stock portfolio performance using the most current stock prices compared to buying […]Schedule recurring expenses in a calendar in excel (Personal Finance)

Below is an excel table containing recurring expenses and corresponding amounts, dates and recurring intervals. An excel table allows you to […]### 14 Responses to “Bill reminder in excel”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

This is really helpful!

Can you explain how to modify it to display a running total of bills due by date? What I'm envisioning doing is plotting that as my projected bank balance (including sources of income as "negative bills").

Your other tutorials explain how to handle the plotting, but I'm not sure how to generate the running total itself.

Keith,

Is this what you are looking?

Formula in cell F2:

yes , similar to what is narrated above.

This xls worksheet is almost what i am looking for. I am looking to have a drop down list of pay days, and have it auto populate the bill due from that paycheck if the bill due day, which is always the same number each month falls within two paydays. For example, If a bill due date falls during two dates (paydays) then the bill would need to come out of the earlier paycheck. Does that make since?

David,

I made a version with drop down lists:

Bill-reminder-version2.xlsx

The current date (today) decides which bills are displayed. Try changing the date in cell C2, sheet Reminder.

this is a very nice worksheet, but I was wondering, just what does the drop down on the bills page have to do with anything in the formulas, or is it just so that you/me, know that it is a monthly, bimonthly quarterly... bill?

Thomas,

If I remember this correctly, the frequency is important. The array formula uses the frequency to calculate what months the bill is displayed.

Great worksheet!

Question: I have a bill that must be paid every two weeks. How would I be able to modify the frequency in Bills worksheet?

how come it does not work for me? In reminder tab, it keep saying "name" Please help

Kevin,

The IFERROR function does not work in excel 2003.

Is there anyway to import the payment due dates into a printable calendar? I have seen other templates with perpetual calendars that can be populated from a list simular to your template but yours is the only one I have found so far that put bills in like I would like.

Bill

Is there any way to make this formula not dependent on the current month or current day? For example, my bills don't change from month to month but my pay dates do. I just want to populate the list of bills I have to pay with each check without having to enter the month or have it rely on the 'TODAY' function. I was trying to see if there was a way to list the bills just by the range of the pay dates but I couldn't figure it out. I'd be really interested to know.

does this work within MS office 2016?

Can you help me. I get paid weekly, what do I chang the formula too.