Formula for creating a time sheet in Excel

[gmac7]

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.

 

[Raphael]

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]

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.

 

[Raphael]

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

 

[Whinyguy]

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.