## Result of Multiplying a Date formated Cell

346 Views 8 Replies Latest reply: May 1, 2012 12:56 AM by AJWZZ
Calculating status...
Currently Being Moderated
Apr 30, 2012 4:57 AM

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
• Level 4 (3,310 points)
Currently Being Moderated
Apr 30, 2012 6:59 AM (in response to AJWZZ)

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

• Level 7 (27,365 points)
Currently Being Moderated
Apr 30, 2012 8:00 AM (in response to AJWZZ)

Arthur,

Use:

=DUR2DAYS(Date2 - Date1)

to find the number of days between two dates.

Jerry

• Level 7 (27,365 points)
Currently Being Moderated
Apr 30, 2012 10:04 AM (in response to AJWZZ)

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:

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

• Level 7 (27,365 points)
Currently Being Moderated
Apr 30, 2012 1:13 PM (in response to AJWZZ)

OK Arthur,

I hope that solves your problem for now.

Jerry

• Level 4 (3,310 points)
Currently Being Moderated
Apr 30, 2012 3:09 PM (in response to AJWZZ)

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

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.