Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 34

Aging Formula Help

I have a worksheet with column AD currently showing the number of days based
upon todays date they are past due. I have the following criteria that I
want the formula to return in column AC if the number in columns D is between
those numbers.

Days:
0-30
31-60
61-120
121-180
181-240
241-300
365+

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Aging Formula	Sue	Excel Discussion (Misc queries)	5	May 2nd 08 10:49 PM
Aging Formula	Steve	Excel Discussion (Misc queries)	6	July 7th 07 12:24 AM
aging formula	Drew	Excel Discussion (Misc queries)	3	April 13th 07 11:12 PM
aging	Rina	Excel Worksheet Functions	2	October 23rd 06 05:50 PM
WHAT FORMULA DO I USE FOR AGING A STATEMENT	ewalbers	Excel Worksheet Functions	1	August 11th 06 05:41 PM

All times are GMT +1. The time now is 01:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us