With July 1, 2005 in A1,
Try this in a cell formatted to General or Number:

=DATEDIF(A1,TODAY(),"d")/7*40

The base formula returns days, so dividing by 7 will yield full and partial
weeks.

If you want to only work with full weeks, adjust it to this:

=INT(DATEDIF(A1,TODAY(),"d")/7)*40

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"_Bigred" wrote in message
...
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