Hi!
One way is to use conditional formatting to highlight the Due Date cell
based on today's date and whether or not a date has been entered in the
Payment Rec'd cell.
A1 = payment due date
D1 = acutal date payment is rec'd
Select cell A1
Goto FormatConditional Formatting
Formula is: =AND(A1<"",TODAY()=A1,D1="")
Click the Format button and maybe select a background color
OK out
Biff
"workin4alivin" wrote in message
...
I want to be able to put in a formula that will tell me if a loan
recipient's
loan is past due.
Column A is payment due date
Column B is payment amount due
Column D is acutal date payment is rec'd
Column E is actual amount received
Any help that anyone can offer will be appreciated, including a formula
that
will work or a different way to set up my workbook to give me what I want.
(Essentially, I have a page for each borrower and a summary sheet on the
front page that shows original loan balance, balance due, late payments,
etc.)
Thank you, Tara
|