Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 -- |
#4
|
|||
|
|||
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |