| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight every other line at one time | Excel Discussion (Misc queries) | |||
| Time Line Graph | Charts and Charting in Excel | |||
| time in subject line | Excel Discussion (Misc queries) | |||
| line chart over time | Charts and Charting in Excel | |||
| TIME LINE? | Excel Discussion (Misc queries) | |||
Hybrid Mode
