I intend to use a plugin for WordPress that takes data from Excel and inserts it into WP to create posts. The
columns include the post, the post title and a timestamp (date)
I have at least a year's worth of posts :-) which
I want to upload
I need to be able to take a starting date and go backwards for a year, simply to save me manually
typing out each date.
The format of the starting date is Mar 19, 2008 16:54:11 PM
The minutes don't
matter - they're just there to make the plugin work
What I want to do though is go back through the months, with
each month being accurate i.e. if there are 30 days in one month, and 31 in another, that's got to be accurate.
I try and do this manually it's going to be mind-numbing.
I've followed the instructions in Excel 2000 without any
Create linear and growth trends with the Series command
When you use the Series command, the resulting series replaces the original selected values. To save the original values,
copy them to a different row or column. Then create the series by selecting the copied values.
Select the cell
where you want to start the series. The cell must contain the first value in the series.
On the Edit menu, point
to Fill, and then click Series.
Do one of the following:
To fill the series down the page, click Columns.
To fill the series across the page, click Rows.
the Step value box, enter the value that you want to increase the series by. In a linear series, the step value is added to
the first starting value and then added to each subsequent value. In a growth series, the first starting value is multiplied
by the step value. The resulting product and each subsequent product is then multiplied by the step value.
Type, click Linear or Growth.
In the Stop value box, enter the value you want to stop the series at.
Note If there is more than one starting value in the series and you want Microsoft Excel to generate the trend, select the
Trend box. In a linear series, the starting values are applied to the least-squares algorithm (y=mx+b) to generate the
series. In a growth series, the starting values are applied to the exponential curve algorithm (y=b*m^x) to generate the
series. In either case, the step value is ignored. The series created is equivalent to the values returned by the TREND
function or the GROWTH function.
I've also tried creating a starting date, and then a date one day less above it, and dragging the corner handle up the page,
but all I get is a list of identical dates, even when I right click on this and try and see if there are any options.
Any help would be greatly appreciated.