Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Fomula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Fomula
"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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Fomula
Oops! Forgot to mention that the invoice date is in column B.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Fomula
Thanks. But in my aging i just need to show how long does it take to
receive an item from the day it was shipped. There are no amount involved in this situation. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aging Fomula
"Aileen" wrote in message oups.com... Thanks. But in my aging i just need to show how long does it take to receive an item from the day it was shipped. There are no amount involved in this situation. The formulae I gave you can be easily adapted to that. Aileen. Take a closer look. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating an aging report | Excel Worksheet Functions | |||
Fomula | Excel Discussion (Misc queries) | |||
How can I use fill hand to copy the fomula in this case? | Excel Discussion (Misc queries) | |||
aging formulas | Excel Worksheet Functions | |||
To copy fomula | Excel Worksheet Functions |