Assuming:
You are trying to age your receivables
Column A has Due Dates, B has a calculation for overdue days, C has
Aging
Data is from A3 downwards
You have Today's date in Cell C1
Write the following formula in Cell B3
=IF(A3>=$C$1,"Not Due",$C$1-A3)
Write the following formula in Cell C3
=IF(B3="Not
Due","Current",IF(AND(B3>0,B3<31),"00-30",(IF(AND(B3>30,B3<61),"31-60",IF(AND(B3>60,B3<91),"61-90","Over
90")))))
Copy both formulas along your due dates in Column A
Is that what you are looking for?
Regards
Aqib Rizvi
Second condition
Click Add
Change Condition 2 to Formula Is
Add a formula of =AND(A1<>"",A1<TODAY()+60)
Click the Format button
Select the Pattern Tab
Select an amber
OK
OK
Third condition
Click Add
Change Condition 2 to Formula Is
Add a formula of =AND(A1<>"",A1<TODAY()+90)
Click the Format button
Select the Pattern Tab
Select an green
OK
OK
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Splatme" <Spl...@discussions.microsoft.com> wrote in message
news:45285778-4B34-44F8...@microsoft.com...
~Jen
DOUG