Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weeks in Excel 2000 | Excel Discussion (Misc queries) | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Calculating time difference | Excel Discussion (Misc queries) | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
Weeks in a Calendar | Excel Discussion (Misc queries) |