A ass98 New Member Joined Aug 30, 2002 Messages 31 Sep 12, 2002 #1 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.
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.
J Juan Pablo González MrExcel MVP Joined Feb 8, 2002 Messages 11,959 Sep 12, 2002 #2 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
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
A ass98 New Member Joined Aug 30, 2002 Messages 31 Sep 12, 2002 #3 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
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
J Juan Pablo González MrExcel MVP Joined Feb 8, 2002 Messages 11,959 Sep 12, 2002 #4 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.
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.