time line
 

hi i need a time line to be generated from a start finish date
start date finish date
24/5/05 26/6/05
i need the time on three rows the first showing the month the second
showing the date and the third showing the day as the next illustration

May June
24 25 26 27 28 29 30 31 1 2 3
mon tue wed thur fri
first off is it possible in excell
second if so how do you do it
third if not is there something that will work
all replies will be most gratefull
cheers

time line
 

you don't really need code for ths.
In A1 put the first date, then B1 = A1+ 1
copy b1 to the right
A2 =A1
A3 =A1
copy A2 & A3 to the right
Format row1 as 'MMM'
format row 2 as 'dd'
format row 3 as 'DDD'

"pgc" wrote:

hi i need a time line to be generated from a start finish date
start date finish date
24/5/05 26/6/05
i need the time on three rows the first showing the month the second
showing the date and the third showing the day as the next illustration

May June
24 25 26 27 28 29 30 31 1 2 3
mon tue wed thur fri
first off is it possible in excell
second if so how do you do it
third if not is there something that will work
all replies will be most gratefull
cheers