Ok maybe I can explain this better than my previous attempt... I am trying
to stream line my work flow so I have created a "Monthly Results" sheet that
has a single field D4 where the user will input the first day of the month
ex. "03/01/2007".

I have below D4 a cell that should return the sum of the "hours on" (column
B) for the month represented by the single date entry found in D4. How can I
set my criteria to ref the single date in D4 but look for the entire month?

thanks
- will