Here's the answer to your question. The b2:b20 range needs to refer to
the column where you would input the hours worked; a2:a20 needs to
refer to your date range. You'll notice the {} brackets - this means
it is an array formula - you don't actually type these, you will hit
Ctrl+Shift+Enter when you are finished entering the formula (instead of
hitting Enter) and these will be automatically added. This means that
excel calculates on the entire range instead of just the first entry.
Let me know if you have questions or problems. Later - Chad

{=MAX((B2:B200)*A2:A20)}


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=514612