Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating with weeks
Hi I am looking for a way to calculate by weeks. Eg
I have a file that contains start date Start date 07/05/2007 06/30/2007 Column B will have number of employees in position Column C will have the number of referrals I would like column D to reflect the start date to count how many weeks it is to current week multiplied by referrals (column c) then divided by number of employees in position. Similar to the below Start date No. of empl # of referrals column D 07/05/2007 2 1 ((# of weeks from 07/05/2007 to 07/12/2007) X 1) / 2 Thanks Fawn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating with weeks
The definition of a week need finalising, but this works on the number of
days =ROUND((TODAY()-A2)/7,0)*C2/B2 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Fawn" wrote in message ... Hi I am looking for a way to calculate by weeks. Eg I have a file that contains start date Start date 07/05/2007 06/30/2007 Column B will have number of employees in position Column C will have the number of referrals I would like column D to reflect the start date to count how many weeks it is to current week multiplied by referrals (column c) then divided by number of employees in position. Similar to the below Start date No. of empl # of referrals column D 07/05/2007 2 1 ((# of weeks from 07/05/2007 to 07/12/2007) X 1) / 2 Thanks Fawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating number of weeks between two dates | Excel Worksheet Functions | |||
Formula for calculating the last four weeks | Excel Discussion (Misc queries) | |||
Calculating number of weeks from two dates | Excel Discussion (Misc queries) | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
calculating weeks worked | Excel Worksheet Functions |