Timebase help!!!

Discussion in 'Excel' started by Catw0327, Apr 10, 2012.

  1. Catw0327

    Catw0327

    Joined:
    Apr 10, 2012
    Messages:
    2
    Likes Received:
    0
    Hi

    I'm new to office forums, and i'm having problem with my excel sheet.

    i'm trying to make a timebase sheet, which when i enter today's date and it will show the number of day left on my products.

    for example:

    TODAY'S DATE ENTER HERE ==> 04/10/12
    YellowGreen if the products less than 120 days[/COLOR]Less Than 120 Days (10% OFF) less then 90 daysLess Than 90 Days (20% OFF)
    less then 60 daysLess Than 60 Days (30%OFF) less than 30 daysless than 30 days (50%)
    BARCODE Descriptions EXPIRE DATE NO. OF DAY LEFT
    7/31/2013 477
    4/30/2014 750
    8/31/2014 873
    7/31/2013 477
    04/30/2012 21


    once i change to today's date the NO. OF DAY LEFT will change and if they are less than whatever day that i set it automatically change to that color
     
    Catw0327, Apr 10, 2012
    #1
    1. Advertisements

  2. Catw0327

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    I doubt Catw0327 even cares about this any more (question is over 4 years old) but I'll answer anyway for whomever may care.

    Assume A1 is 7/31/2013 and B1 is 477
    =TODAY()-A1 The trick here is to format the result correctly. For example:

    6/15/2016 - 7/31/2013 = 11/15/1902 Changing the format of 11/15/1902 to General or Number gives us 1050. This product hasn't just expired, it's turned to dust. Can't even give it away now. o_O
     
    XLPadawan, Jun 16, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. build

    maths help

    build, May 1, 2011, in forum: Excel
    Replies:
    2
    Views:
    691
    XLPadawan
    Jun 16, 2016
  2. bookerk2

    help with conditional formatting

    bookerk2, May 4, 2011, in forum: Excel
    Replies:
    1
    Views:
    621
    XLPadawan
    Jun 16, 2016
  3. jsduiahd
    Replies:
    0
    Views:
    589
    jsduiahd
    Jul 26, 2011
  4. Nago
    Replies:
    0
    Views:
    517
  5. Mark

    Help Fill Series

    Mark, Apr 4, 2013, in forum: Excel
    Replies:
    1
    Views:
    1,052
    XLPadawan
    Jun 16, 2016
  6. caziscarol

    Excel help recording hours

    caziscarol, Oct 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    509
    chimpytech
    Apr 12, 2014
  7. Peter Kaufmann

    Lookup Function Help

    Peter Kaufmann, Nov 8, 2014, in forum: Excel
    Replies:
    1
    Views:
    344
    Peter Kaufmann
    Nov 13, 2014
  8. trent92

    Percent Help

    trent92, Jul 19, 2016, in forum: Excel
    Replies:
    2
    Views:
    169
    trent92
    Jul 20, 2016
Loading...