can a cell remind you of an upcoming bill date payment

G

Guest

i am trying to have a bill sheet inform me of upcoming payments of different
bills. is there a way to crreat a formula that will do just that. to remind
me of an upcoming pay event at least 4 days before the actual bill pay period?
 
G

Guest

With your date in A1, enter the following formula in B1:
=IF(AND(A1>=TODAY()-4,A1<=TODAY()),"payment due","")
You could use the same first part of the formula for conditional formatting
in either A1 or B1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating the number of pay-dates before a bill is due? 4
how to count my paydays before the due-date of a bill? 11
Date and amount of last payment 3
date calculations 11
Payment cell populated based on date formula 6
Excel/Access template to enter/sort utility bill info 1
Create a calendar report in access 3
Problem w/ cell reference 2

Top