maybe something like

=SUMPRODUCT(--(MONTH('unfunded deals'!A:A)=MONTH(TODAY())),--YEAR('unfunded
deals'!A:A)=YEAR(TODAY()))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashley0578" wrote
in message ...

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=533059