| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create an aged column
Hi there,
I'm trying to create a formula that shows me the following based on the date of invoice. Aged 30 Aged 60 Aged 90 Aged 120 Aged 180 Aged 240 etc upto 360 then Aged Over 1 year This is a really tough if statement I think but I'm not so great at anything other than basic if statements. Any help would greatly appreciated. Tx Suzanne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column has emails & other stuff. Want to create a column w/ just e | Excel Worksheet Functions | |||
| Aged Debt - grouping values by date range | Excel Discussion (Misc queries) | |||
| how do I update a column and create new rows for new column cells | Excel Discussion (Misc queries) | |||
| how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
| How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
Threaded Mode
