Creating Timeline

[komark]

Hi,
I need to create a timeline for a period of 6 months. I was wondering if i could use macro to do that.

thanks in advance

 

[GlennUK]

Please explain what you mean by timeline? It's not a normal Excel term ... so are you talking about a project timeline, as in a Gantt chart?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

You are talking about Excel aren't you??????

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

If you just want a set of dsates across that period, then put the first date in say cell B2, the second in C2, select both, then grab the bottom right of your selection where you see the little black cross and just drag it as far as you need.

Or

1st date in B2, then if you want days for example, in C2 put =B2+1, then copy across.

=B2+7 gives you weeks.

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------