Seeking Countdown Formula

[Guest]

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?

 

[Guest]

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

 

[Guest]

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, (e-mail address removed)

Regards

winston