Mulevariant
New Member
- Joined
- Dec 2, 2004
- Messages
- 17
Hello
I am trying to write the following formula with no luck:
1. IF the date in cell "S2" is 10 days earlier than today's date
2. AND the text in cell "AW2" DOES NOT EQUAL "DESP"
3. Return a value of "OVERDUE".
4. If not, return a blank cell.
Can anyone help please?
Thanks
I am trying to write the following formula with no luck:
1. IF the date in cell "S2" is 10 days earlier than today's date
2. AND the text in cell "AW2" DOES NOT EQUAL "DESP"
3. Return a value of "OVERDUE".
4. If not, return a blank cell.
Can anyone help please?
Thanks