Excel date formula

C

Carol

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

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

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