Hi!

Try this:

A1 = 7/1/2005

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

Biff

"_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