Making fixture list's

Duzzer · 07-18-2008, 04:43 PM

Was after some help. I do the fixtures for my hockey club and have been doing for many years and to produce the fixture lists I manually input all the dates and now i'm thinking surely this is an easy equation for exel to do. I'm looking for it to have in the first column 30-Aug-08 which is a Saturday and then to automatically put the date in for next Saturday up to the 29-Mar-09. So in simple terms want the date of every Saturday from 30/08/08 to 29/03/09.

Thanks in advance Duzzer

David M58 · 07-18-2008, 05:48 PM

Here’s one way to do it.

In cell A1, enter 30-Aug-08.

In cell B1, enter this formula:

=A1+7

Copy the formula in cell B1 to the range C1:AE1.

Duzzer · 07-19-2008, 02:19 AM

Thanks for that David just done that and it works great done =A1 +7 then next block down =A2 +7 then it works great. Do I have to write that equation in every row or is there a way of auto filling it up to a certain date?
Regards Duzz

Duzzer · 07-19-2008, 02:55 AM

found a help file on exel you type in date then next line =A1 +7 then drag cursor down column and it auto fills the dates cheers for your reply anyhow;)

07-18-2008, 04:43 PM	#1 (permalink)
Duzzer Registered User Join Date: Jun 2006 Posts: 41 OS: XP	Making fixture list's Was after some help. I do the fixtures for my hockey club and have been doing for many years and to produce the fixture lists I manually input all the dates and now i'm thinking surely this is an easy equation for exel to do. I'm looking for it to have in the first column 30-Aug-08 which is a Saturday and then to automatically put the date in for next Saturday up to the 29-Mar-09. So in simple terms want the date of every Saturday from 30/08/08 to 29/03/09. Thanks in advance Duzzer

07-18-2008, 05:48 PM	#2 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 97 OS: Windows XP SP3	Re: Making fixture list's Here’s one way to do it. In cell A1, enter 30-Aug-08. In cell B1, enter this formula: =A1+7 Copy the formula in cell B1 to the range C1:AE1.

07-19-2008, 02:19 AM	#3 (permalink)
Duzzer Registered User Join Date: Jun 2006 Posts: 41 OS: XP	Re: Making fixture list's Thanks for that David just done that and it works great done =A1 +7 then next block down =A2 +7 then it works great. Do I have to write that equation in every row or is there a way of auto filling it up to a certain date? Regards Duzz

07-19-2008, 02:55 AM	#4 (permalink)
Duzzer Registered User Join Date: Jun 2006 Posts: 41 OS: XP	Re: Making fixture list's found a help file on exel you type in date then next line =A1 +7 then drag cursor down column and it auto fills the dates cheers for your reply anyhow;)