bpeltzer Wrote:
You'd need to replace today()-30 with a calculation that returns the
beginning of the month: today()-day(today())+1.
If you want a specific month, I'd use two countif functions, along the
lines
of
=COUNTIF('unfunded deals'!A:A,"="&date(2006,1,1)) - COUNTIF('unfunded
deals'!A:A,"="&date(2006,2,1)). That would count the number in Jan
'06 (all
those from 1/1/06 on, minus all those from 2/1/06 on, leaving only
those in
January)

Thanks for the help! Let me explain what I've done in the workbook so
far...
This workbook has three sheets; unfunded deals, funded deals and a
sheet for a recap with just the numbers. I used the countif() statement
to count the number of deals from the today's date minus a certain
amount of days. Column A has the dates in it. The dates are formatted
like April 17, 2006. So, from today - 30 there are 18 unfunded deals
left. While the formula above would work, this would mean that I
would have to change the formula in the workbook once a month. Is
there a way that would look at today's date (April 17, 2006), extract
the month April and count those in Column A with the month April?


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