IF Function with multiple outcomes???

[hotdogs1999]

Hello all,


new to this forum, and pretty new to excel, so here goes my first question.


i have one column that has dates in it for 'Follow Up' alerts. have made a formula so if the date is between a certain range then a message shows in the next cell.


my formula currently is =IF((AND(J24=(TODAY()+1),J24<(TODAY()+3))),"UPDATE PENDING","")


this is only doing 1 part of what i need though.


what i'm after is a formula that gives the following:
- if between 1&3 days from now - display "UPDATE PENDING" - which i have done in the above formula
- if today - display "UPDATE TODAY"
- if <today (past) - "OVERDUE"


i can then conditionally format them to change colour depending on what the message is.


would much appreciate some help on this


thanks in advance

 

[Fluff]

What are you using for the CF?

 

[hotdogs1999]

working fine now, thanks.

 

[Fluff]

Ok, thanks for letting me know