Bob Phillips Wrote:
=COUNTIF('unfunded deals'!A:A,"="&TODAY()-30)-COUNTIF('unfunded
deals'!A:A,"="&TODAY())


I see where you are going with this but it's giving me the same result,
and not the actual month-to-date. Any other suggestions??? I know if I
wanted to find the actual month only using a full date in Access, I'd
use Between DateSerial(Year(Date()),Month(Date()),1) And Date() to
yield all the results of this month.


--
ashley0578
------------------------------------------------------------------------
ashley0578's Profile: http://www.excelforum.com/member.php...o&userid=32757
View this thread: http://www.excelforum.com/showthread...hreadid=533059