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
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