| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHAT FORMULA DO I USE FOR AGING A STATEMENT
I am trying to age a statement for current - 31 to 60 days - 61 to 90 days
and over 90. How do I get excel to figure out which amount goes in what column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WHAT FORMULA DO I USE FOR AGING A STATEMENT
Are you saying that you want a formula to give you a date that is a fixed
number of days from some other date? If A1 has a date and you want a date 60 days from that date placed in B1, us this formula in B1: =A1+60. HTH Otto "ewalbers" wrote in message ... I am trying to age a statement for current - 31 to 60 days - 61 to 90 days and over 90. How do I get excel to figure out which amount goes in what column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| if date statement or formula | Excel Discussion (Misc queries) | |||
| IF statement when formula result is blank | Excel Worksheet Functions | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
| If statement formula | Excel Worksheet Functions | |||
Hybrid Mode
