calculating progressive months

[latete]

I'm a newbee to this board. I'm entering enter a date (October 1, 2002) in say A1. then, starting in A2 through A362, I want to have each row display the next month. Currently, I am using a formula to add 31 to previous field (formular for A3= "=a2+31", A4= "A3+31" and so on. That doesn't work each time because some months have 30,31,28 days. By the time I get to the the fifth year, It starts to skip a month approximately every five years. How can I do this accurately? Thanks,

Latete

 

[Corticus]

Hi,

1 way, using EDate()

Book1
	A	B	C	D
1	10/1/2002
2	11/1/2002
3	12/1/2002
4	1/1/2003
5	2/1/2003
6	3/1/2003
7	4/1/2003
8	5/1/2003
9	6/1/2003
10	7/1/2003
11	8/1/2003
Sheet1

EDate requires the analysis toolpak

-or-

=DATE(YEAR(A1),MONTH(A1)+1,1)

without the toolpack.

HTH,
Corticus

 

[Aladin Akyurek]

On 2002-10-18 16:40, Corticus wrote:
Hi,

1 way, using EDate()

[..]

EDate requires the analysis toolpak

-or-

=DATE(YEAR(A1),MONTH(A1)+1,1)

without the toolpack.

HTH,
Corticus

The equivalent of

=EDATE(A1,1)

would be

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
This message was edited by Aladin Akyurek on 2002-10-18 16:47

 

[Corticus]

Tru,

My formula will go to the first day of the next month.

10/05/02 would go to
11/01/02

Thanks Aladin.

 

[IML]

just because it is a slow friday, techincally I think
=MIN(DATE(YEAR(A3),MONTH(A3)+1,DAY(A3)),DATE(YEAR(A3),MONTH(A3)+2,0))

would be the exact the equivilant of
=EDATE(A3,1)

 

[latete]

Thanks all. I was able to use the EDATE function. It worked like a charm. Thanks,again.

Latete

 

[Legacy 11273]

You might also like to consider doing it without a formula.

Select your range of cells, go to Edit>Fill>Series and select Type(Date), DateUnit(Month), StepValue(1).