# Formula for creating a time sheet in Excel

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

#### 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.

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

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.

over 807,865 other people just like you!