IF AND function with a DATE calculation

[willow1985]

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

 

[AhoyNC]

Try:

Excel Workbook
	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
Sheet

 

[willow1985]

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

 

[willow1985]

I figured it out. was referencing H2 only.

Thank you for all of your help!!!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.