Formula = Today's date + 1 month
On Tue, 7 Feb 2006 18:37:18 -0600, daddylonglegs
wrote:
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
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
|