CountIf by month

I have a workbook that uses this function:

=COUNTIF('unfunded deals'!A:A,">="&TODAY()-30).

My only problem is that I actually need to count by month. How can I rewrite this so that it will show me, for instance, Month-to-date?

See response in other group.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashley0578" <[email protected]> wrote
in message news:[email protected]...
>
> I have a workbook that uses this function:
>
> =COUNTIF('unfunded deals'!A:A,">="&TODAY()-30).
>
> My only problem is that I actually need to count by month. How can I
> rewrite this so that it will show me, for instance, Month-to-date?
>
>
> --
> ashley0578
> ------------------------------------------------------------------------
> ashley0578's Profile:
http://www.excelforum.com/member.php...o&userid=32757
> View this thread: http://www.excelforum.com/showthread...hreadid=533058
>