Excel date formula

[Guest]

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!

 

[R.VENKATARAMAN]

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.

 

[Arvi Laanemets]

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

 

[Myrna Larson]

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.