Main Menu

A list of comic dates on computer? HOW?

Started by SmallBlueThing, 15 October, 2012, 08:10:47 PM

Previous topic - Next topic

SmallBlueThing

Here's what I want to do, but I don't know how to do it:

I want to print a long list of the cover dates for the 80s/90s EAGLE and 70s/80s BATTLE, in the following format:

BATTLE

13/05/79   20/05/79   27/05/79   03/06/79   10/06/79 etc

on A4 paper, so I can fold them up and put them in my wallet and carry them around with me for when I'm unexpectedly in a junk shop, or on eBay and am confronted with lovely comics. However, I need a way of working out the dates and printing them without physically and laboriously sitting here and typing them up- which would drive me mental.

Also, I don't know the dates of leap years and if or when the comics changed the days of publication. Is there some bizarre site on the interwebz that has this kind of info, without me having to cut and paste dates from a comic site? Basically, I want someone to do it for me... preferably without me having to pay them. Does anyone know of somewhere this can be done?

SBT
.

Banners

Create a Google spreadsheet which will be accesible from your phone, replete with the dates in a column, ready to be ticked off. That way you don't even need the paper.

SmallBlueThing

.

Definitely Not Mister Pops

If you could get a list of ALL the cover dates, then you could just highlight the ones you have and delete huge blocks of dates in one go, leaving you with the ones you don't have.
You may quote me on that.

Definitely Not Mister Pops

#4
You may quote me on that.

Dandontdare

If you've got Excel (other spreadsheet programmes are available), you can create an ongoing list by typing the first couple of dates in a column and then dragging down the bottom corner to populate the rest of the list.

TordelBack

#6
Quote from: Dandontdare on 15 October, 2012, 08:55:21 PM
If you've got Excel (other spreadsheet programmes are available), you can create an ongoing list by typing the first couple of dates in a column and then dragging down the bottom corner to populate the rest of the list.

Was just going to post exactly what Dan said. 

Excel (or free software like Open Office Calc, Libre Office etc.) uses an algorithm to calculate leap years, so just type your first date (e.g. 01/02/76), then the next week (e.g. 08/02/76) below it in the same column, highlight both boxes, grab the bottom right hand corner of the lower one and drag down the column as far as you want to go.  If you want the results in plain text, just go to File:Export...  and select a format you're happy with.

You may need to set the Data type for the column to Date before you do this, and pick a format you like for your dates, but probably not. 

SmallBlueThing

DDD and Tordleback- I love yous both! Thankyou- sorted!

SBT
.