How do I set up 12-month rolling month cells in excel?

Need to set up 12 cells starting with the current month followed y the next
11 months based on today() as a starting point. Any suggestions?

With TODAY() in cell B2, try this formula:
=EOMONTH(B2,1)
.... then copy and paste into subsequent cells in the continuum.

You may require some experimentation to get your desired results.

On Wed, 30 Nov 2005 11:42:09 -0800, jbh <[email protected]> wrote:

>Need to set up 12 cells starting with the current month followed y the next
>11 months based on today() as a starting point. Any suggestions?


A1: =today()
A2: =edate($A$1,ROW()-1)
copy/drag down

If the EDATE function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron