calculating weeks worked
 

I can calculate estimated out dates for personnel. I'm now trying to figure
out total weeks worked based on a start date and then an end date.

With end date in B1, and start date in A1, use:

=(b1-a1)/7

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"klillestol" wrote in message
...
I can calculate estimated out dates for personnel. I'm now trying to
figure
out total weeks worked based on a start date and then an end date.

Bingo! thanks!

"Fred Smith" wrote:

With end date in B1, and start date in A1, use:

=(b1-a1)/7

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"klillestol" wrote in message
...
I can calculate estimated out dates for personnel. I'm now trying to
figure
out total weeks worked based on a start date and then an end date.