Filter value from date > 3 months from selected date

[Forestq]

Hi,

I have value as below:

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]column A[/TD]
[TD]column L[/TD]
[/TR]
[TR]
[TD]03/04/2015[/TD]
[TD]01/07/2013[/TD]
[/TR]
[TR]
[TD]03/04/2015[/TD]
[TD]22/12/2014[/TD]
[/TR]
[TR]
[TD]03/04/2015[/TD]
[TD]10/11/2014[/TD]
[/TR]
[TR]
[TD]03/04/2015[/TD]
[TD]06/09/2013[/TD]
[/TR]
[TR]
[TD]03/04/2015[/TD]
[TD]15/08/2014[/TD]
[/TR]
</tbody>[/TABLE]

Now in column AA, I want to add flag "1" when, it have passed over 3 month between date from column A and column L.
In column AB, I want to have also flag, when it have passed over one year, between date from column A and column L.

How to do it? Function DAYS360?

 

[williamgowtama]

in VBA, date can be considered as decimal values. for example, 3rd march, 2015 would be 42066, while 3rd June, 2015 would be 42158. simply use if then function and u are good to go

 

[Forestq]

I need to do it from excel perspective, use functions etc...

 

[Aladin Akyurek]

In AB2 enter and copy down:

=(DATEDIF(A2,L2,"m")>=3)+0

 

[Forestq]

In AB2 enter and copy down:

=(DATEDIF(A2,L2,"m")>=3)+0

I got "#NUM"

 

[Aladin Akyurek]

I got "#NUM"

The dates in L are smaller than the ones in A.

So, it looks like you want in AA:

=(DATEDIF(L2,A2,"m")>=3)+0

And in AB:

=(DATEDIF(L2,A2,"y")>=3)+0

 

[Forestq]

thanks!

 

[Aladin Akyurek]

thanks!

You are welcome.