COUNTIF for dates old than a specific value

[iboumiza]

Hi there,

I'm looking to create this rule in my COUNTIF formula:

=COUNTIF(A:A, Dates in column A are 90 days old or less)

The date format is m/dd/yyy

Kindly assist me, please

Regards
iboumiza

 

[Andrew Poulsom]

Does this work for you?

=COUNTIF(A:A,"<"&TODAY()-90)

 

[su_maverick]

Are you looking for the date to be a running value? As in 90 days older than today?

Excel has a TODAY function that can be used.

	RETURN VALUE	CODE
Today	8/28/2014
90 days ago	5/30/2014	=TODAY()-90
180 days ago	3/1/2014	=TODAY()-180
365 days ago	8/28/2013	=TODAY()-365

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[su_maverick]

Does this work for you?

=COUNTIF(A:A,"<"&TODAY()-90)

Beat me by a minute

 

[iboumiza]

both of you rocks!!! Thanks much guyz!!!