Insert text based on date
 

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

I have this foumula in cell B7:
=IF(AND(A7<(TODAY()-14),K7=""),"14-31days old",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

Insert text based on date
 

=IF(K7="",IF(A7<TODAY()-31,"31 days old",IF(A7<TODAY()-14,"14-31 days
old","<14 days old")),"K7 not blank")

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

"honyacker" wrote:

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

I have this foumula in cell B7:
=IF(AND(A7<(TODAY()-14),K7=""),"14-31days old",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

Insert text based on date
 

Thanks Sloth.
Works excellent!

Joe

"honyacker" wrote in message
...
I posted a question earlier using Conditional Formatting.
I want to do it differently now.

I have this foumula in cell B7:
=IF(AND(A7<(TODAY()-14),K7=""),"14-31days old",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