Thread: IF AND function with a DATE calculation Thanks:  1 Post #5346254 (1) Likes:  1 Post #5346254 (1)

1. IF AND function with a DATE calculation

Hello,

I am hoping someone could help me clean up a formula of mine.

I am looking to have the formula calculate between the current date and date received and then if this result is greater than 5 AND another cell ="0" return a "true" result, other wise "false".

This is the formula I wrote but I am missing something....

=if(and((DATEDIF(TODAY(), G2, "d")>5),H2="0","true","false")

I hope someone can help me with this.

Thank you

Carla

2. Re: IF AND function with a DATE calculation

Try:

 G H I J 1 Date Rec. 2 9/23/2019 0 FALSE 3 9/12/2019 TRUE 4 8/30/2019 TRUE 5 9/20/2019 FALSE

 Cell Formula J2 =IF(AND(TODAY()-G2>5,\$H\$2=0),"TRUE","FALSE")

Excel tables to the web >> Excel Jeanie HTML 4

3. Re: IF AND function with a DATE calculation

This formula did not work.
A date appeared in column H. Since it was not "0" it should have returned a FALSE however it returned "TRUE".

Both conditions have to be met to return a true, a date greater than 5 and H = 0 (aka no date).

am I missing something?

Thank you

Carla

4. Re: IF AND function with a DATE calculation

I figured it out. was referencing H2 only.

Thank you for all of your help!!!!

5. Re: IF AND function with a DATE calculation

You're welcome. Thanks for the feedback.

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•