=IF(AND(E3=TODAY(),E3<=TODAY()+3),"True","False")
returns true but only for today..I need for today + 3 days
=IF(AND(E3=TODAY(),E3<=TODAY()+3),"True","False")
returns true but only for today..I need for today + 3 days
maybe: =IF(OR(E3=TODAY(),E3<=TODAY()+3),"True","False")
E3 cannot be TODAY() and TODAY()+3 in the same time
Got it.....instead of AND it should be OR
=IF(OR(E3=TODAY(),E3<=TODAY()+3),"True","False")
Thanks a lot.
You left out a greater than sign in the first section of the AND. This works for me:
=IF(AND(E3>=TODAY(),E3<=TODAY()+3),"True","False")
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
You are welcome
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If E3 will contain function TODAY() not a hardcoded date you can't do that because today TODAY() tomorrow will be also TODAY()
if E3 will be hardcoded date eg.04/10/2017 you can use formula from above: =IF(AND(E3>=TODAY(),E3<=TODAY()+3),TRUE,"")
with TRUE and FALSE you don't need quotation marks because TRUE and FALSE are Boolean values treated as 1 or 0
AND()
OR()
IF()
Logical functions
Last edited by sandy666; 10-04-2017 at 02:09 AM.
@tuph
That is what I said a one post earlier
Got it...thanks a lot guys, highly appreciate your help.
You are welcome
If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
If you did it - ignore it.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks