software

I posted a question earlier using Conditional Formatting.
I want to do it differently now.

I have this foumula in cell B7:
=IF(AND(A7lt;(TODAY()-14),K7=quot;quot;),quot;14-31days oldquot;,0)

I need to modify it to only enter the text if it is between 14 and 31 days
older than TODAY()
Right now, it will use the text if it is any date older than 14 days.
If it is older than 31 days, I want it to do something different.

Thanks,
Joe
=IF(K7=quot;quot;,IF(A7lt;TODAY()-31,quot;gt;31 days oldquot;,IF(A7lt;TODAY()-14,quot;14-31 days
oldquot;,quot;lt;14 days oldquot;)),quot;K7 not blankquot;)

I added some error messages to make the function easier to follow.

quot;honyackerquot; wrote:

gt; I posted a question earlier using Conditional Formatting.
gt; I want to do it differently now.
gt;
gt; I have this foumula in cell B7:
gt; =IF(AND(A7lt;(TODAY()-14),K7=quot;quot;),quot;14-31days oldquot;,0)
gt;
gt; I need to modify it to only enter the text if it is between 14 and 31 days
gt; older than TODAY()
gt; Right now, it will use the text if it is any date older than 14 days.
gt; If it is older than 31 days, I want it to do something different.
gt;
gt; Thanks,
gt; Joe
gt;
gt;
gt;

Thanks Sloth.
Works excellent!

Joe

quot;honyackerquot; gt; wrote in message
...
gt;I posted a question earlier using Conditional Formatting.
gt; I want to do it differently now.
gt;
gt; I have this foumula in cell B7:
gt; =IF(AND(A7lt;(TODAY()-14),K7=quot;quot;),quot;14-31days oldquot;,0)
gt;
gt; I need to modify it to only enter the text if it is between 14 and 31 days
gt; older than TODAY()
gt; Right now, it will use the text if it is any date older than 14 days.
gt; If it is older than 31 days, I want it to do something different.
gt;
gt; Thanks,
gt; Joe
gt;
gt;