Counting based on DATE values

Hi guys,

just having a small problem, i have 2 colums 1 with names and 1 with dates, like in the file i attached :count.xlsx
what i have to do is like : i need to count the names of which dates are not older than 3 months (1 quarter). shortly , if there are 3 out of 4 names that are between today and the date of 3 months ago, they should be counted. i get in trouble with the dates, always getting me "value" errors. any ideas?

See the attached modified workbook. This work is done using 2 things(Autofilter for the date range & worksheet function SUBTOTAL:COUNT).

Originally Posted by DGagnon

test this out and see if you get the result you are looking for

=COUNTIF(D6:D9,">"&TODAY()-90)

it kinda helped, i was looking a formula with EDATE function or EOMONTH but i guess this does the magic.

Originally Posted by Dennis7849

See the attached modified workbook. This work is done using 2 things(Autofilter for the date range & worksheet function SUBTOTAL:COUNT).

if i try to add a date that is older than 3 months , it still counts the name. so its not working for me

Originally Posted by DGagnon

i could change it to specificaly look for 3 months ago, what date would it be looking for as of today? Feb 1st, or Jan 5th?

Jan 5th should it be.

Originally Posted by DGagnon

Try it like this

=COUNTIF(D6:D9,">"&DATE(YEAR(TODAY()),MONTH(TODAY())-3,DAY(TODAY())))

it works pretty good, but if i change from 1/1/2012 to 2/1/2012 it still counts it , tho today() returns the 5th of April. Substracting 3 months would be 5th of January, so any value under 5th of Jan should not be counted.

Originally Posted by DGagnon

2/1/2012 is February 1st, so it should be included.

Right, it's working good . I misunderstood the date format. Thank you very much!