This formula goes in cell F3
=IF(AND(E3>=TODAY(),E3<=TODAY()+3),"Due","Overdue")
in cell G3 if it says "Paid", I would like the cell F3 to be empty (nothing
to say due or overdue).
I tried ....
=IF(AND(OR(E3>=TODAY(),E3<=TODAY()+3),"Due","Overdue"), F3="")
returns #VALUE!
hi there. you can use it like this:
=IF(G3="Paid","",IF(AND(E3>=TODAY(),E3<=TODAY()+3),"Due","Overdue"))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
It works, but dates before today and today+3 days it returns "overdue"Originally Posted by benishiryo
It works, but dates before today and after today+3 days it returns "overdue",
I would like it to be empty/blank cell.
Just change "overdue" to ""
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
why is it CF only highlights 1 cell ? please see the image attached. thanks.
formula used is
=AND(F1>=TODAY(),F1<=TODAY()+2)
pic1.PNG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks