Thread: Does countifs support imbedded formula's ? "Example included"

Thats the formula :-

=COUNTIFS(PLATES,CS2,LDATE,">40025",LDATE,"<40057",ORIGIN,"PS")

What i want is to replace ">40025" and "<40057" which between them exists the month of august of 2009 with other two formulas that will constantly give me values that will also have the month we are in inbetween them, i used these two:-

1- =EOMONTH(NOW(),-1)
2- =EOMONTH(NOW(),0)+1

this was my final formula:-

=COUNTIFS(PLATES,CS2,LDATE,EOMONTH(NOW(),-1),LDATE,EOMONTH(NOW(),0)+1,ORIGIN,"PS")

but its not working?!!

whats wrong?!!

You still need to include the > and < operators, eg:

=COUNTIFS(PLATES,CS2,LDATE,">"&EOMONTH(NOW(),-1),LDATE,"<"&EOMONTH(NOW(),0)+1,ORIGIN,"PS")