Date

Give an alternative option so that i can get the series of dates in this way,
1.1.08, 01.02.2008, 01.03.2008, ..so on , instead of typing

Put the first date in A1.
In B1, put:
=A1+1 and copy across
--
Gary''s Student - gsnu200796

The usual format for dates would be 1/1/08 not 1.1.08.

If you are using American style dates then enter 1/1/08 in A1 and drag down
on the fill handle - left click on the little square at the bottom righ-hand
corner the of the cell and drag down to index the date up one day.

If you are using British style dates so that you are indexing it in months
not days then enter 1/1/08 in A1 and 1/2/08 in A2, highlight both and then
drag down on the fill handle.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"C.M." wrote in message
...
Give an alternative option so that i can get the series of dates in this
way,
1.1.08, 01.02.2008, 01.03.2008, ..so on , instead of typing