Posted to microsoft.public.excel.misc

Sue

external usenet poster

Posts: 285

Aging Formula

Have the following formula for aging, would like for it to age credit
balances in the current column. Can I add something to these formulas to
make it work

Cell Q1 is date to age from, Cell G2 is invoice date, cell H2 is invoice
balance.

formula for Current column
=IF($Q$1=($G2+1),IF($Q$1<=($G2+30),$H2,""),"")

formula for 1-30 Days Past Due
=IF($Q$1=($G2+31),IF($Q$1<=($G2+60),$H2,""),"")

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	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
aging workbook	mlouie	New Users to Excel	6	May 12th 06 07:15 PM

All times are GMT +1. The time now is 09:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us