seting up schedules sheets using excel

Discussion in 'Windows Desktop Systems' started by the_music_man, Sep 19, 2004.

  1. the_music_man

    the_music_man aka prodj88 =P

    Messages:
    2,401
    Location:
    USA
    hey im tryin to make an excel sheet basically so i can use it to record my working hours. i just want two columns (date and hours worked) and a "total" row for each biweekly period.

    my question is how do i set it up so i don't have to type monday sept 20th, then tuesday sept 21st, wednesday sept 22nd etc?..... i just wanna set it up so it can put all the dates for each month on a sheet or soemthing similar.
     
  2. Khayman

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

    Messages:
    5,518
    Location:
    England
    A simpler way is to type somthing like
    10/01/04
    Then go to format->cells->date-> select the date format you want (01 October 2004, for example) ->OK
    Then you can simply drag that cell down the column and it will increase the date for each cell