hotdogs1999
Board Regular
- Joined
- Dec 11, 2018
- Messages
- 57
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
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