Sequencial dates in a column

  • Thread starter Thread starter EdF
  • Start date Start date
E

EdF

Excell 2000: In a column I want to enter dates in
sequencial order such as:
01JN04
02JN04
03JN04

Is there a way to have the numbers self generate the next
sequencial date rather than enter each individualy?
I'm new to Excell
 
Hi, EDF.

If these are true dates (in your format), you should be
able to select the last 2, then put your cursor over
the lower right corner (cursor turns to + ) and drag
down.

jeff
 
Hi, EDF.

If these are true dates (in your format), you should be
able to select the last 2, then put your cursor over
the lower right corner (cursor turns to + ) and drag
down.

jeff
 
Is there a way to have the numbers self generate the next
sequencial date rather than enter each individualy?
Click to expand...

To a degree, with text formulas. If 01JN04 is in A1, then in A2 you could
use

=RIGHT("0"&LEFT(A1,2)+1,2)&RIGHT(A1,4)

.. Then you could drag this down using the Fill Handle -- the small black
square at the bottom right corner of the selected cell. This would give you
June's dates ; you'd need to start July's (01JY04, presumably) manually.
When done, you could copy the range & Edit -- Paste Special -- Values -- OK,
to convert the formula results to actual values. But with your "dates" in
that format, Excel can't interpret them as such in any calculations you
might need, so you could come unstuck later anyway.

HTH,
Andy
 
Not self-generating, but enter a date in A1 and in A2 enter =A1 + 1

Drag/copy down as far as you want.

Gord Dibben Excel MVP
 
Back
Top