View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
honyacker
 
Posts: n/a
Default 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