| 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) | |||
Linear Mode
