# Need Help writing a formula for personal bills

#### LEROYHOP

##### New Member
I trying to set up a formula were I will put in the due dates of my bills and within 15 days of the due date I wont the formular to post the text Due. Once I pay the bill i will put the amount i paid in the amount paid cell once i do that I wont the Due to change to Paid.

This is what i have so far =IF(E7,"Paid","DUE") but the Due is always there. Also i have it where The due is red and the paid is grenn With the help of conditional formating.

Just need help with making it say due 15 days prior and paid when i put the amount paid.

Due Date 15-Jan-06 Due Date 15-Jan-06
Amount Due \$149.00 Amount Due \$149.00
Amount Paid Amount Paid \$149.00
Balance \$169.00 Balance \$20.00
DUE Paid

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### Peter100

##### Well-known Member
try
=IF(A3>0,"PAID",IF(B3-TODAY()<15,"DUE",""))

where column A holds the paid amount and column B is the due date

#### LEROYHOP

##### New Member
WORKS

THANK YOU IT WORKS GREAT

Replies
2
Views
261
Replies
0
Views
195
Replies
7
Views
182
Replies
11
Views
113
Replies
2
Views
132