• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

2003 Excel Time Query


OSNN Addict
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?



In the beginning......
Political User
Excel stores dates as a number, so many days past 1st Jan 1980 I believe, so number 10 will be 10 Jan 1980 etc.


I'm sorry Hal...
Political User
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


OSNN Addict
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!


OSNN Addict
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 posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
What a long strange trip it's been. =)

Forum statistics

Latest member