calculating with weeks

  • Thread starter Thread starter Fawn
  • Start date Start date
F

Fawn

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
 
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)
 
Back
Top