If statements referring to different ranges of dates/flagging up

[smokejunkie]

Hi guys,

=IF(A7>=(TODAY()+13),"2 WEEKS","")

The above is for a basic spreadsheet where A7 is an intake date and the formula cell flags how long an item is still unsorted, this kind of does the job but i would like the addition of 3 weeks and 4 weeks to be highlited in the same cell?

=IF(A7>=(TODAY()+13),"2 WEEKS","") IF(A7>=(TODAY()+20),"3 WEEKS","")

The above is obviously not working doh!

Also, how do you get to fomat the text so it will come up in red?

Thanx for your time.

[protonLeah]

How about:

Please Login or Register  to view this content.

which results in:

Today()=04/13/08:

04/20/08 "2 weeks"
04/27/08 "3 weeks"
04/28/08 "3 weeks"
05/04/08 "4 weeks"
05/05/08 "4 weeks"
05/10/08 "4 weeks"