Remember Me?

#1
October 30th 04, 12:52 AM
 klillestol Posts: n/a
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.

#2
October 30th 04, 02:12 AM
 Fred Smith Posts: n/a

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

=(b1-a1)/7

--
Regards,
Fred

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

#3
October 30th 04, 04:26 AM
 klillestol Posts: n/a

Bingo! thanks!

"Fred Smith" wrote:

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

=(b1-a1)/7

--
Regards,
Fred

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Glenys T Excel Discussion (Misc queries) 2 January 11th 05 03:43 PM J Dizzle Fizzle Excel Discussion (Misc queries) 1 December 31st 04 07:47 PM Robyn Bellanger Excel Discussion (Misc queries) 2 December 23rd 04 02:29 AM LolaK Excel Discussion (Misc queries) 1 December 14th 04 04:23 PM GregR Excel Discussion (Misc queries) 2 December 9th 04 12:55 AM

All times are GMT +1. The time now is 08:50 PM.