+ Reply to Thread
Results 1 to 8 of 8

Tying sheets and Automatic Age Counting

  1. #1
    Registered User
    Join Date
    02-15-2008
    Posts
    4

    Tying sheets and Automatic Age Counting

    Hi,

    I'm new to excel apart from the simplist of spreadsheets but I know it is a power tool and I would like to use it to its full advantage.

    I have a workbook that I would like to connect the data from the first sheet to the rest of the sheets. So I could change a figure in a column in sheet1 and it would automaticly update the rest of sheets that corressponds to that column.

    Also I would like to know if there is a formula that could auto age/count from a specific date for example:

    say the date was 2008-01-25 in column G and age to the present date would be 21 days in column I and the next day it would automaticly update it to 22 days and so on.

    I'm not sure if this is possible.

    thanks in advance

    Baz
    Last edited by bazh; 02-15-2008 at 08:35 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    This formula will link a cell toA1 in Sheet 1

    To get the number of days use this formula, assuming you have the original date in A1.
    =TODAY()-A1
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    02-15-2008
    Posts
    4
    royuk

    here is what I would like to acheive

    Part ID Part Description HUB-ID Free Stock Status Date Received Age

    540-6 assy rack * CW037 29 * STCK *2008-02-04 8

    Then the next day it will automaticly read as follows:

    Part ID Part Description HUB-ID Free Stock Status Date Received Age

    540-6 assy rack CW037 29 STCK 2008-02-04 9

    I only want the age to change automaticly like some kind of day counter

    thanks

    Baz

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I can't tell what you want. Can you attach an example workbook, you will need to zip it.

  5. #5
    Registered User
    Join Date
    02-15-2008
    Posts
    4
    Hi roy

    here is the workbook i'm working on its the sheets titled hub id that have the date and age. I just want the age to change everyday so when I add a part on the sheet I will put the date I received it and the age would start at 0 and the next day would be 1 and count up each day until the part is taken from the stock.

    thanks

    Baz
    Attached Files Attached Files

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    How are you entering the datas/ They are not entered as dates.

  7. #7
    Registered User
    Join Date
    02-15-2008
    Posts
    4
    They are American dates that are copy and pasted from another data base.

    I dont mind adjusting them but as long as they stay in American format.

    thanks
    Baz

  8. #8
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You will need to re-enter them I think. Excel does not seem to recognise them as dates. You can create a Custom date format. From the Format menu select Cells, then scroll down the category list to Custom. In the Type box enter yyyy-dd-yy. Then click OK.

    The formula that I gave you will work when you key in the dates.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1