RE: Date/If function for past dues

FSt1 and Biff,

Both of your suggestions worked. But my problem now is getting this
information to show on the summary ***. I want a column that shows whether
an account is overdue or not, which could allow me to link a cell on the
summary page to each client loan page.

I am no expert in Excel, but I was thinking I needed to do some type of IF
statement. Only, I can't figure one out that would work.

Below is the data as I have it set up on each clients work***.

Date Amount Cr.amt Date Amount Check #
9/1/2004 25.00 25.00 8/31/2004 ($25) 902
10/1/2004 25.00 25.00 9/18/2004 ($75) 914
8/1/2005 25.00 25.00
9/1/2005 25.00 25.00
10/1/2005 25.00

Currently, cell A2, A3, A4 are pink background and A5 and A6 are white
background.
Cell C2, C3, C4 and C5 are blank and C6 is pink. (Conditionally formatting-
Column A is pink if before Now and COlumn C formatted if amount is under
$25.00.
Row 5 is all white, therefore this client is up-to-date on payments.

This works, but I can't see a way to show on the summary page that the
account is overdue or not. Any help is appreciated! Thanks, Tara


"FSt1" wrote:

> hi,
> forgot to mention.
> highlight the a column and conditional fomat the whole column.
>
> regards
> FSt1
>
> "FSt1" wrote:
>
> > 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
.