RE: Date/If function for past dues

hi,
in column E you could put

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

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

then click the format button>patterns. 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 *** on the
> front page that shows original loan balance, balance due, late payments,
> etc.)
>
> Thank you, Tara
.

Loading