Count how many dates are this month, 2 months and 3 months old

Hi all,
I have this formula

Please Login or Register  to view this content.

which counts how many dates it finds this current month.

I'm trying to figure out how to edit this so i can use it to count for all dates last month. And then i'll need another that counts dates from 2 months ago, but i'm sure i could work that out once i have a code for last month.

Any ideas?

Stuart

Try


=COUNTIFS(D1:D3,">="&EOMONTH(TODAY(),-2)+1,D1:D3,"<="&EOMONTH(TODAY(),-1))

will give results for May

Count for all dates last month:


=COUNTIFS(D1:D3,">="&EOMONTH(TODAY(),-2)+1,D1:D3,"<="&EOMONTH(TODAY(),-1))

Please Login or Register  to view this content.

these are the bits you need to change, last month is -2 and -1
2 months ago are -3 and -2

That's great guys! Thanks for the help

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.