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