Date problem & other.

Hey im really new at this forum, and i have excel experience like 20 hours max.
I need help to do my dates , i have to get all days on my excel thing from day 22.4.2002 to this day., anyone willing to help fool me ? :I
and then i need to get this thing sort out the most used numbers. (this is kind of lottery calculating thing) from 1 to 70 most used numbers and stuff.. if someone helps i might come up with new problems cheers

Welcome to the forum.

Do you have an example sheet we can look at?

So you are wanting all days from 22.04.2002 all the way to today 03.11.2009?

That will be a BIG list! Like over 3000+ days

Counting the numbers 1-70 is no problem. You'd use a simple COUNTIF

I've attached a worksheet for you to see.

If you want more days just highlight the last day in the column , click and hold the little black square and drag all the way down.

thanks alot... its just ....
https://www.veikkaus.fi/tuloshaku?op...20&results_of=
i need to type all those "oikea rivi" things on each 1 2 3 4 -> 20
......... its quite alot of damn letters :P, is there any way i can just copypaste them like row at a time ? :S

To copy and paste them a row at a time would be dependant on how the webpage is designed.

From my intial look you wouldn't be able to.

I also looked into doing a web query external data for you but it didn't recognise the table on the webpage, even though it uses <tr></tr> tags.

What do you mean by combined? Download my above attached work book and look

All ive done is created a list of 1 - 70 and it will count the amount of times them numbers are used...

now i remember what i needed, the average usage of a number in week . from 1 to 70 :P