On Fri, 07 Oct 2005 01:06:27 GMT, "_Bigred" wrote:

I want to create a field(s) in Excel 2003 that will allow me

to enter a hard (non-changing date) and have it calculate how many weeks
have eclipsed since that time and then multiply to 40 hrs per week to give a
total of work hours that have passed since the date

The Date desired to use is July 1st, 2005 and counting.....

TIA,
_Bigred



With your date in A1, something like

=(TODAY()-A1)/7*40

Or if you want to count only workdays at 8 hrs/day, you could use the
NETWORKDAYS function.

=NETWORKDAYS(A1, TODAY(), holidays) * 8

See HELP for this function. It requires installation of the Analysis Tool Pak
and HELP will tell you how to do that.


--ron