Splatme wrote:
What would the formula look like to highlight cells, by date (month and
year), as the date approaches? ie... 90, 60 or 30 days out.


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(B30,B3<31),"00-30",(IF(AND(B330,B3<61),"31-60",IF(AND(B360,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