inserting a date function

[ass98]

i have designed a piece of software to run a sports league. The only problem is how can i insert a date automatically for every week.

 

[Juan Pablo González]

What do you mean automatically ? when the workbook is opened ? or do you mean, you put in a start date, and Excel calculates the other dates ? if so you can just use a formula, for example, to get the next week you just add 7

=A1+7

 

[ass98]

yes i need excel to calculate the dates from one date specified in a cell.

i need the date to change only if the week number changes.

i needs to be something like:
if week number = week number then date else date + 7
This message was edited by ass98 on 2002-09-12 16:55

 

[Juan Pablo González]

What I'm saying is, if for example you have in A1

12/09/02

and you put this formula in A2 and drag down

=A1+7

you'll get the dates from today, next thursday, the one after that one, etc.