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
rewrite this so that it will show me, for instance, Month-to-date

--
ashley057
-----------------------------------------------------------------------
ashley0578's Profile: http://www.excelforum.com/member.php...fo&userid=3275
View this thread: http://www.excelforum.com/showthread.php?threadid=53305

CountIf by month
 

See response in other group.

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