2003 Excel Time Query

Discussion in 'Windows Desktop Systems' started by cpomd, Jun 9, 2005.

  1. cpomd

    cpomd OSNN Addict

    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
     
  2. Ohzopants

    Ohzopants My mom thinks I'm cool

    Messages:
    165
    Location:
    Montreal
    i have always found working with dates and times confusing as hell in Excel... good luck
     
  3. rushm001

    rushm001 In the beginning...... Political User

    Messages:
    3,480
    Location:
    Norfolk, UK
    Excel stores dates as a number, so many days past 1st Jan 1980 I believe, so number 10 will be 10 Jan 1980 etc.
     
  4. Khayman

    Khayman I'm sorry Hal... Political User Folding Team

    Messages:
    5,518
    Location:
    England
    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
     
  5. RickyC

    RickyC OSNN Addict

    Messages:
    199
    Location:
    Earth
    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!
     
  6. cpomd

    cpomd OSNN Addict

    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