Ask Your Question

Working with dates to product lists [closed]

asked 2013-03-19 15:30:29 +0100

kickoff3pm gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 01:45:24.151044

2 Answers

Sort by » oldest newest most voted

answered 2013-03-19 16:16:22 +0100

horst gravatar image

Type your (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.

edit flag offensive delete link more

answered 2013-06-30 13:24:45 +0100

mikeymike gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-03-19 15:30:29 +0100

Seen: 194 times

Last updated: Jun 30 '13