Excel date formula
 

I need to a formula that would produce in column A a running series of dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):

1/03/2004
1/04/2004
1/05/2004
etc....

Thank you for any help!

type in any cell

=1/3/04
take mouse toright hand bottom which turn into a +sing.
drag it down

I hope you mean jan 3, jan 4 etc.


Carol wrote in message
...
I need to a formula that would produce in column A a running series of
dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):

1/03/2004
1/04/2004
1/05/2004
etc....

Thank you for any help!

Hi

Into topmost cell (p.e. A1) enter the start date
Into next cell (p.e. A2, when started not from A1, adjust cell references)
enter the formula
=A1+1
and format as date
Copy the cell with formula down as much you need.
I hope the dates you did give were from January - otherwise, when the step
is a month, the formula for cell A2 will be different. With Analysis
Toolpack Add-In installed:
=EMONTH($A$1,ROW()-1)
or, when start date is less than 28th of month, then using basic Excel
functions
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Carol" wrote in message
...
I need to a formula that would produce in column A a running series of
dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):

1/03/2004
1/04/2004
1/05/2004
etc....

Thank you for any help!

If you type =1/3/4, that means to divide 1 by 3, then divide the result by 4,
i.e. 1/12 = 0.8333. If you want a date, you DON'T normally precede it with an
equal sign.


On Wed, 2 Feb 2005 11:23:05 +0530, "R.VENKATARAMAN"
$$$ wrote:

type in any cell

=1/3/04
take mouse toright hand bottom which turn into a +sing.
drag it down

I hope you mean jan 3, jan 4 etc.


Carol wrote in message
...
I need to a formula that would produce in column A a running series of
dates
without having to type them in individually. I need it such as (not
necesarily in numerical form):

1/03/2004
1/04/2004
1/05/2004
etc....

Thank you for any help!