Nested DATEDIF in IF function

[CraigExcelQ]

Hi there,

I'm struggling to figure out where I'm going wrong. So this is what I have written out so far:

=AND(IF(DATEDIF(K2,K3,"M")=<48,1,0),IF(A2=A3),1,0))

Essentially, if the difference between the two dates in K2 and K3 are lass than 48 months, and the value in A2 and A3 is the same, I'm looking for it to return true, but I always get an error. I thought I'd need to nest the DATEDIF function within IF.

Any ideas where I've gone wrong?

 

[Fluff]

How about

=AND(DATEDIF(K2,K3,"M")=<48,A2=A3)

 

[Saurabhj]

Hi, While using DATEDIF formula, make sure: K3 > K2

 

[CraigExcelQ]

=AND(DATEDIF(K2,K3,"M")=<48,A2=A3)

Returns #NUM! unfortunately

 

[CraigExcelQ]

Returns #NUM! unfortunately

Scratch that, it works!, Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.