hi,
in column E you could put

=if(A2<Now(), "Overdue","")

or you could use conditional formating.
go Formatconditional format
enter Cell value is less than =now()

then click the format buttonpatterns. pick a bright color to high light
the overdue cell.

regards
FSt1

"workin4alivin" wrote:

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