Working with dates to product lists

[kickoff3pm]

I have a need to product a list of dates in a spreadsheet column. Here’s what I need;

1. I set a starting date - example 1970-01-30
2. I select week or month.
3. A list is produced of dates for each period - for example;

For weeks
1970-01-30
1970-02-06
1970-02-13

For months
1970-Jan
1970-Feb
1970-Mar

Would be handy if I could format the date.
These will not be updated, I just need to product the list and then they will be treated a text.

[horst]

Type your 1.date (1970-01-30) in one cell.

Select this cell and all the cells you want your weeks/Months in.

Menue:Edit ->Fill → Series

In the window select Days (for weeks) and enter “7” in the “Increment” data field. There is no selection for weeks. For your month select Month and “1” in the “Increment” field.

Afterwards you can format the cells. Right-click the selected cells, select “Format cells” and under tab “Numbers” select date and date-format.

[mikeymike]

An alternate method is to put the first and second date/numbers in the series, then use fill down (select both cells first, then use fill down).