8 Replies Latest reply: May 1, 2012 12:56 AM by AJWZZ
AJWZZ Level 1 Level 1 (0 points)

I have recently started using Numbers and having trouble with the date and format options.  I am trying to calculate the number of days between two dates and then multiplying the result by a value. 

 

I have been able to format the to and from dates using the date format.  The result is given in days.  When I multiply this day cell by a value the result is given in days and I want it to be the value

 

Can anyone help

 

Regards

 

Arthur


iMac
  • 1. Re: Result of Multiplying a Date formated Cell
    jaxjason Level 4 Level 4 (3,325 points)

    havent tried your specific situation today by a few days ago someone posted something similar and the solution was utlizing the "durationTo" functions to convert your number into a more useful format for mathematics.

     

    Jason

  • 2. Re: Result of Multiplying a Date formated Cell
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    Arthur,

     

    Use:

     

    =DUR2DAYS(Date2 - Date1)

     

    to find the number of days between two dates.

     

    Jerry

  • 3. Re: Result of Multiplying a Date formated Cell
    AJWZZ Level 1 Level 1 (0 points)

    Thanks very much.  I played around with these but found that I could not get a value out of it.  I am now leaning towards using the "round' function to convert date data into a value.  It is all very time consuming and requiring a lot of different calculations.  I am beginning to think it may be worth returning to returning to Excel.

     

    Just to complete my disappointment.  I purchased my Numbers directly from Apple but there is no telephone support for Numbers.  (My imac still qualifies for telephone support)  When contacting Apple they directed me to the web site and to see if I could find a solution.  I do not have the time to wade through all the FAQ and feel this is not what I have come to expect from Apple.

     

    Thanks again for your replies.

     

    Regards

     

    Arthur

  • 4. Re: Result of Multiplying a Date formated Cell
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    Arthur,

     

    I'm sorry about your disappointment. Numbers is a capable spreadsheet program that differs from Excel in some ways and has fewer features, but also has some unique features. Nothing about your problem statement is difficult in Numbers and there is nothing that you will learn in a phone call to Apple that we can't help you with here.

     

    Anytime you begin using a new piece of software you must expect to invest an hour or two in reading the user guide, at least the first couple of chapters. This is important even if you do eventually go to an Apple tutor. It's important to know the terminology and the basics as they are presented out in the User Guide, available for download from the Help menu.

     

    Here is an example of your exact problem statement, with as much accuracy as is possible with the amount of detail you provided:

     

    Screen Shot 2012-04-30 at 12.54.37 pm.png

     

    Date 1 is in Column A, Date 2 is in Column B and the difference is in Column C. This difference in Column C is in the units of Duration, in this case the result "5d" is a duration of 5 days. Column D converts this duration to a pure numeric value. Column E does the multipliation. Of course you could collapse all that calculation business into one cell. The one cell version would be: =DUR2DAYS(B-A)*5.5

     

    Regards,

     

    Jerry

  • 5. Re: Result of Multiplying a Date formated Cell
    AJWZZ Level 1 Level 1 (0 points)

    Jerry

     

    Thanks very much for coming back to me.  Before calling Apple I tried using the help functions and could not get the information you have given me.  I fully understand that using a new program there is always a learning curve, but I spent the best part of the day trying to get to the bottom of this, and I am sure you will understand my frustration.

     

    I appreciate your reply and for taking the time to explain it to me.

     

    Regards

     

    Arthur

  • 6. Re: Result of Multiplying a Date formated Cell
    Jerrold Green1 Level 7 Level 7 (28,990 points)

    OK Arthur,

     

    I hope that solves your problem for now.

     

    Jerry

  • 7. Re: Result of Multiplying a Date formated Cell
    jaxjason Level 4 Level 4 (3,325 points)

    What is the format setting on your two date columns? If it isn't date then I think that will mess it up too.

     

    Jason

  • 8. Re: Result of Multiplying a Date formated Cell
    AJWZZ Level 1 Level 1 (0 points)

    Hi Jason

     

    Thanks - I have formated the cells to a date format - but you may be interested in the Jerry's advice.  I will be giving this a try.

     

    Thanks again for your input.

     

    Regards

     

    Arthur