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

That is effectively what that formula is doing.

Can you give an example of the data, what that formula returns, and what you
expect to see?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashley0578" wrote
in message ...

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

I've attached the file I've been working on (names removed to protect
the innocent!).

What I expect to see on the recap sheet is the total amount of deals
unfunded for the month to date, which for this month would be April 1 -
April 19. Below that, I would see a sum of the total amount of money we
would expect to see from those customers by the end of their loan.

This would be the same for week to today (Sunday thru today).

All of this would be repeated for the funded deals and turndowns.


+-------------------------------------------------------------------+
|Filename: Deal Log example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4658 |
+-------------------------------------------------------------------+

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

I have posted a workbook at http://cjoint.com/?etrwzrGdLu

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ashley0578" wrote
in message ...

I've attached the file I've been working on (names removed to protect
the innocent!).

What I expect to see on the recap sheet is the total amount of deals
unfunded for the month to date, which for this month would be April 1 -
April 19. Below that, I would see a sum of the total amount of money we
would expect to see from those customers by the end of their loan.

This would be the same for week to today (Sunday thru today).

All of this would be repeated for the funded deals and turndowns.


+-------------------------------------------------------------------+
|Filename: Deal Log example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4658 |
+-------------------------------------------------------------------+

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