Seeking Countdown Formula
 

I am using Excel 2003 and would like to insert a formula that would plug a
number in each cell (each cell represents a different week) based on a the
duration of a contract (given in weeks)

For example, a contract's duration is 14 weeks, I would like to have each of
our weekly cells automatically display a sales figure (eg. 600 dollars)right
until the contract expires.

Cell A1: Contract duration (in weeks)
Cell B1, C1, D1..........(calandar weeks)

Any ideas?

Seeking Countdown Formula
 

Not many - at least not until I know where the sales figures are coming from?

"Winston" wrote:

I am using Excel 2003 and would like to insert a formula that would plug a
number in each cell (each cell represents a different week) based on a the
duration of a contract (given in weeks)

For example, a contract's duration is 14 weeks, I would like to have each of
our weekly cells automatically display a sales figure (eg. 600 dollars)right
until the contract expires.

Cell A1: Contract duration (in weeks)
Cell B1, C1, D1..........(calandar weeks)

Any ideas?

Seeking Countdown Formula
 

jlatham:

my apologies. the sales figures are coming from a different column on the
spreadsheet. As a revision:

Cell A1: Contract duration (# of weeks)
Cell B1: Weekly sales ($$, fixed)
Cell C1,D1,E1............:Weeks of the year (Jan 1-7,8-14, 15-22, etc)

If you can email me directly, that would help me even more,

Regards

winston



"JLatham" wrote:

Not many - at least not until I know where the sales figures are coming from?

"Winston" wrote:

I am using Excel 2003 and would like to insert a formula that would plug a
number in each cell (each cell represents a different week) based on a the
duration of a contract (given in weeks)

For example, a contract's duration is 14 weeks, I would like to have each of
our weekly cells automatically display a sales figure (eg. 600 dollars)right
until the contract expires.

Cell A1: Contract duration (in weeks)
Cell B1, C1, D1..........(calandar weeks)

Any ideas?