Thank you very much. Your second email did the trick!! I really appreciate
your help!
Kind regards,
John

"JW" wrote:

On Oct 15, 10:07 pm, hjburk wrote:
Opps, I meant I need the X to move horizontally.

"hjburk" wrote:
Hi folks,
I'm trying to create a heavily modified accounts receivable aging report. I
think an example will help explain my intent.

CUSTOMER DATE "DESCRIPTION" 0-30 31-60 61-90 90+

Microsoft 10/15/07 Computer Monitor X
Boeing 9/1/07 Radio Equip. X

What I would like this to do is, have the "X" automatically move laterally
from column to column as time passes from the date entered in column B.

Thank you very much for your help. Kind regards, John

After re-reading your post, I realized that you probably want this to
be via formulas, not VBA. If so, you can use formulas like the ones
below. Assuming that your dates are in column B and your
0-30,31-60,61-90, and 90+ column are D, E, F, and G respectively.

Formula in D2:
=IF((TODAY()-B2)<=30,"X","")

Formula in E2:
=IF(AND((TODAY()-B2)<=60,(TODAY()-B2)=31),"X","")

Formula in F2:
=IF(AND((TODAY()-B2)<=90,(TODAY()-B2)=61),"X","")

Formula in G2:
=IF((TODAY()-B2)90,"X","")