1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Formula for creating a time sheet in Excel

Discussion in 'Business Applications' started by gmac7, Dec 29, 2001.

Thread Status:
Not open for further replies.
Advertisement
  1. gmac7

    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.
     
  2. Raphael

    Raphael

    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.
     
  3. gmac7

    gmac7 Thread Starter

    Joined:
    Dec 29, 2001
    Messages:
    3
    Yes if you could clarify this that would be great thanks.
     
  4. Raphael

    Raphael

    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!!
     
  5. Whinyguy

    Whinyguy

    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.
     
  6. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/63433

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice