Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Dates and %'s

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have 2 sheets with various dates and prices on them with regards to stock, what i need to do is link them to a third sheet with this data being the outcome;

    Products more than 6 months old - 30% off price
    Products more than 9 months old - 60% off price

    I also need to make the % variable by the user and am not allowed to use macros.

    Could anyone help me with this please ?

    Thanks very much

    Anx



  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ..or is there a way to extract dates from a column that are before a certain date please?

    Thanks
    Anx

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Up


  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Your problem statement is rather vague. Provide some sample data and specify precisely the desired results.

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok, I have a list of dates (and prices relating to them) from which i need to calculate which ones are more than 6 months old and which are more than 9 months old from a variable date to be entered by the user.

    when this has been worked out i should now have 2 lists of dates.

    From these dates I need to reduce the prices by 30% for dates more than 6 months old and 60% for dates more than 9 months old.

    I am also not allowed to use a macro.

    Help!!

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    12/06/2001 77.14
    20/08/2001 77.14
    01/06/2001 77.14
    15/06/2001 114.30
    25/04/2001 114.30
    08/05/2001 114.30
    19/10/2001 114.30
    09/08/2001 80.19
    20/11/2001 80.19

    etc etc

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Okay, how about...

    ******>
    DatePriceMonthsNew Price
    6/12/0177.14930.86
    8/20/0177.14754.00
    6/1/0177.141030.86
    6/15/01114.3945.72
    4/25/01114.31145.72
    5/8/01114.31145.72
    10/19/01114.35114.30
    8/9/0180.19756.13
    11/20/0180.19480.19
    11/20/0180.19480.19

    ...where...

    'Months' uses =DATEDIF('Date',TODAY(),"M")
    'New Price' uses ='Price'*CHOOSE(SUM(('Months'>={0,6,9})+0),1,0.7,0.4)

    Note: TODAY() can be replaced by a reference to a cell containing a valid data value.

    [ This Message was edited by: Mark W. on 2002-04-08 10:24 ]

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Brilliant, thanks very much

    Anx

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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