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