seting up schedules sheets using excel

the_music_man

aka prodj88 =P
Joined
2 Jul 2002
Messages
2,401
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.
 
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
 

Members online

No members online now.

Latest profile posts

Also Hi EP and people. I found this place again while looking through a oooollllllldddd backup. I have filled over 10TB and was looking at my collection of antiques. Any bids on the 500Mhz Win 95 fix?
Any of the SP crew still out there?
Xie wrote on Electronic Punk's profile.
Impressed you have kept this alive this long EP! So many sites have come and gone. :(

Just did some crude math and I apparently joined almost 18yrs ago, how is that possible???
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.

Forum statistics

Threads
62,015
Messages
673,494
Members
5,621
Latest member
naeemsafi
Back