Decreasing date by one day for at least a year

Hi,

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.

If I try and do this manually it's going to be mind-numbing.

I've followed the instructions in Excel 2000 without any success.

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.

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


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

Excel may not be reading your date and time as a date and time.

Enter 19/03/2008 in say A1 then in A2 enter =A1-1 and drag down

VBA Noob

Hi,

Just adding to VBA Noob suggestion, then CUSTOM format the cell to mmm dd, yyyy hh:mm