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

J

jbh

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?
 
D

Dave O

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

Ron Rosenfeld

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?
Click to expand...


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
 
Top