How to Auto fill dates on a schedule

[cardingtr]

I am working on a scheduler grid for1 month period.

How do you auto fill the dates by just typing when the schedule starts?

Example: First day of schedule is Oct 10, 2005
On cell A1 should be: 10/10 Mon
B1 is 10/11 Tue
C1 is 10/12 Wed
And so on...

Thanks.

[Max]

One way ..
Enter the starting date in A1
Format A1 as Custom, Type: m/d ddd
Put in B1: =TEXT($A$1+COLUMNS($A$1:A1),"m/d ddd")
Copy B1 across as many columns as required
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cardingtr" <[email protected]> wrote
in message news:[email protected]...
>
> I am working on a scheduler grid for1 month period.
>
> How do you auto fill the dates by just typing when the schedule
> starts?
>
> Example: First day of schedule is Oct 10, 2005
> On cell A1 should be: 10/10 Mon
> B1 is 10/11 Tue
> C1 is 10/12 Wed
> And so on...
>
> Thanks.
>
>
> --
> cardingtr
> ------------------------------------------------------------------------
> cardingtr's Profile:
http://www.excelforum.com/member.php...o&userid=27027
> View this thread: http://www.excelforum.com/showthread...hreadid=470113
>

[Max]

Think this revision is better, as it preserves the dates in row1 as numbers
(instead of text), thus enabling downstream calcs on the dates in row1 (if
required)

Format row1 as Custom, Type: m/d ddd
Enter the starting date in A1
Put in B1: =$A$1+COLUMNS($A$1:B1)
Copy B1 across as many columns as required
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Max]

Correction ..
> Put in B1: =$A$1+COLUMNS($A$1:B1)

should read as:
Put in B1: =$A$1+COLUMNS($A$1:A1)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--