Date

  • Thread starter Thread starter C.M.
  • Start date Start date
C

C.M.

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top