Formula for creating a time sheet in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

gmac7

Thread Starter
Joined
Dec 29, 2001
Messages
3
I'd like to create a time sheet in Excel where in one cell you can type in a pay period like : April 15, 2001 and that would automatically update the cells below it to coresponde with that date.

example:
cell one: April 15, 2001

cells: 4/1, 4/2.....to 4/15.


Thanks.
 
Joined
Jun 20, 2001
Messages
382
a1 = 4/15. copy paste special paste link to o2. n2= o2-1. Then just click in cell n2, and drag the fill handle till a2. If you need more clarification I'll be glad to explain this in more detail.
 

gmac7

Thread Starter
Joined
Dec 29, 2001
Messages
3
Originally posted by Raphael
a1 = 4/15. copy paste special paste link to o2. n2=date o2-1. Then just click in cell n2, and drag the fill handle till a2. If you need more clarification I'll be glad to explain this in more detail.
Yes if you could clarify this that would be great thanks.
 
Joined
Jun 20, 2001
Messages
382
ok, click in cell a1 type in the date you need i.e. 4-15.
right click, copy, right click cell o2, paste special >paste link.
click on cell n2, click on the = in the formula bar, type o2-1.
(cell n2 should now be 4/14)
click on cell n2, in the lower right corner you will see that there is a little piece detached. click on it and drag till a2.
Hope that explains it!! If not, let me know!!
 
Joined
Dec 8, 2001
Messages
270
Just one other clarification to the steps Raphael gave you. If you wanted this to be a "column" of numbers below the A1 cell rather than in a single row you would

Copy cell A1
Click on cell A16
Paste special, paste as link
Click on cell A15
Enter formula = A16-1, ok
Drag the right lower corner of cell A15 to cell A2

This gives you the column rather than the row. When you change the value in cell A1, the other values change accordingly.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top