"Aileen" wrote in message
oups.com...
Hi, I just need some help in making some formulas regarding aging
process.

I just want to show the 91+ 90 60 30 0 days aging process. and not yet
received.

Item item is in c and d row.

thanks


This is your lucky day. I've got a nice aging sheet. Modify the following as
needed.

My amounts are in column E, and my date is in C4. It's shown below as $C$4
to make it an absolute reference. Otherwise, it would increment as I copied
it down the rows, and become C5, C6, etc. I used the cell reference below,
for clarity. But, the better way is to assign a name to your date cell, and
in the formulae below, replace $C$4 with the name, such as "Date" or
whatever. Makes it easier to read. To assign a name, click Insert, Name,
Define, and simply choose a name. There's another way using the mouse, but
that's for crazy people.

My data begins on row 8.

0-30 days - column F:
=IF(($C$4-B8)<31,E8,"")

31-45 days - column G:
=IF(AND(($C$4-B8)=31,($C$4-B8)<=45),E8,"")

46-60 days - column H:
=IF(AND(($C$4-B8)=46,($C$4-B8)<=60),E8,"")

61+ days - column I:
=IF(($C$4-B8)=60,E8,"")

Let me know if these formulae don't make sense. And, I'll assume that the
two cases of Heineken will be delivered by the weekend.