View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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