How to Auto fill dates on a schedule
 

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

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" wrote
in message ...

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

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
--

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
--