I am working on an end of month report.

So on one sheet I have a list of accounts, with one column that has dates
for the last appointment I had with those accounts. Etc:

Account Name Last Visit
1. ABC Mortgage 5/15/2007
2. XWZ Mortgage 5/16/2007

On another sheet I have a report that asks "how many accounts I visited this
month". What I want to do is have the date on the top of the page and then
make a formula that adds all the cells whose dates fall in the month on the
top of the second sheet?

I have been able to use today() to get the date on the top of the page, but
can't figure out how to then reference "last visit" to add up "how many
accounts I visited this month"

Can you help me please?