Try the following:
Col A is dates
Col B is hours worked that day

=SUMPRODUCT((A1:A50TODAY()-28)*(B1:B50))

Hope this helps


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=391217