How to Auto fill dates on a schedule

  • Thread starter Thread starter cardingtr
  • Start date Start date
C

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.
 
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
 
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
 
Back
Top