2003 Excel Time Query

cpomd

OSNN Addict
Joined
6 Jan 2004
Messages
51
I am trying to create a list of dates consisting of every Tuesday and Friday for a period of three months, have tried Autofill but cannot get it to work!!
is there a better way?

Tia
 

Ohzopants

My mom thinks I'm cool
Joined
17 Jan 2004
Messages
165
i have always found working with dates and times confusing as hell in Excel... good luck
 

rushm001

In the beginning......
Political Access
Joined
21 Sep 2002
Messages
3,484
Excel stores dates as a number, so many days past 1st Jan 1980 I believe, so number 10 will be 10 Jan 1980 etc.
 

Khayman

I'm sorry Hal...
Political Access
Joined
6 Jan 2002
Messages
5,518
Create two columns one with the date only in it (eg 09/06/2005 or whatever) Then one next to it with the day (eg Thursday). If you just enter the first date and day you can then drag them down to however long you want.

put a title on each column, then go to autofilter.
next click on the days column filter and select custom, then enter select equals in the top box and enter Tuesday in the box nex to it, then on the bottom 2 select the "or" button and select equals and enter Friday in the other box.

Worked for me
 

RickyC

OSNN Addict
Joined
10 Sep 2004
Messages
199
What Khayman said is the proper way to do it. Just highlight the column first and format the cells so the date shows as you want it, no need to work out the excel number for the date!
 

cpomd

OSNN Addict
Joined
6 Jan 2004
Messages
51
Thank you all for your replies the last one did it. Once again proving the benefits of this forum
once again many thanks
 

Members online

No members online now.

Latest profile posts

hello peeps... is been some time since i last came here.
Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!

Forum statistics

Threads
61,999
Messages
673,424
Members
5,593
Latest member
moussa021