software

I am trying to do the following in A1:480A1 = today's date 1 month
A2 = A1 1 month
A3 = A2 1 month
A4 = A3 1 month

continue that to cell A480

I know that TODAY() will enter todays date but Im not sure how to get
it to read the 1 month part.

help...thanks--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
View this thread: www.excelforum.com/showthread...hreadid=509608
The easiest way is to use the EDATE function, for which you need
Analysis ToolPak enabled

in A1

=EDATE(TODAY(),1)

in A2 copied down

=EDATE(A1,1)

note that with EDATE if today is 31st March EDATE(TODAY(),1) will give
30th April--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=509608If A1 =TODAY()
then =DATE(YEAR(A1),MONTH(A1) 1,DAY(A1))
puts you 1 month later
--
Gary's Studentquot;jermsalermsquot; wrote:

gt;
gt; I am trying to do the following in A1:480
gt;
gt;
gt; A1 = today's date 1 month
gt; A2 = A1 1 month
gt; A3 = A2 1 month
gt; A4 = A3 1 month
gt;
gt; continue that to cell A480
gt;
gt; I know that TODAY() will enter todays date but Im not sure how to get
gt; it to read the 1 month part.
gt;
gt; help...thanks
gt;
gt;
gt; --
gt; jermsalerms
gt; ------------------------------------------------------------------------
gt; jermsalerms's Profile: www.excelforum.com/member.php...oamp;userid=30167
gt; View this thread: www.excelforum.com/showthread...hreadid=509608
gt;
gt;


Gary''s Student Wrote:
gt; If A1 =TODAY()
gt; then =DATE(YEAR(A1),MONTH(A1) 1,DAY(A1))
gt; puts you 1 month later
gt;

..but of course if today is 31st january 2006

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

gives you 3rd March 2006--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=509608On Tue, 7 Feb 2006 18:37:18 -0600, daddylonglegs
gt; wrote:

gt;
gt;The easiest way is to use the EDATE function, for which you need
gt;Analysis ToolPak enabled
gt;
gt;in A1
gt;
gt;=EDATE(TODAY(),1)
gt;
gt;in A2 copied down
gt;
gt;=EDATE(A1,1)
gt;
gt;note that with EDATE if today is 31st March EDATE(TODAY(),1) will give
gt;30th April

The problem with doing it this way is that when you get near the end of a
month, other dates may not be what the OP really wants. For example, on 28-31
Jan 2006, the subsequent dates will be limited to the 28th of the succeeding
months (until 1 Feb 2006).

1/31/2006
2/28/2006
3/28/2006
4/28/2006
5/28/2006
6/28/2006
7/28/2006

If end of month dates are preferable, then, in a1 use the formula:

=edate(TODAY(),ROWS($1:1))

and copy down. Then you get:

1/31/2006
2/28/2006
3/31/2006
4/30/2006
5/31/2006
6/30/2006
--ron


Thanks ron,

I had realised that and edited my post accordingly to suggest something
similar, i.e.

=EDATE(TODAY(),ROW()-ROW(A$1) 1)

(if starting in row 1)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=509608