Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: How to add a number (ie. 8) to a date to output a date +8 days from starting date?

Is there a way that I can type in a date let's say 12-8-17 in a cell, then in another cell have a variable number ie. 8, then combine them together in another cell that would give me 12-16-17? Do I have to convert 12-8-17 to an epoch number, then convert 8 to an epoch number as well, add them both together and then convert back into a date? If so I'm not sure how to do that in numbers. Let me know thanks!

MacBook Air (13-inch, Early 2015)

Posted on

Reply

Dec 12, 2017 8:48 PM in response to ninyota In response to ninyota

Numbers stores dates as date-time values rather than as serial numbers the way Excel does. To make working with dates easy, Numbers has a 'Duration' data format and related functions DURATION, DUR2DAYS, etc. that Excel doesn't have. When you have a valid date-time in a cell (right-aligned by default) you can simply "add" a simple integer to that and Numbers will assume that you mean days. You can use the DURATION() and Date and Time functions when you are adding something other than days. Explanations at Help > Formulas and Functions Help in your menu.


User uploaded file



SG

Dec 12, 2017 8:48 PM

Reply Helpful

Dec 13, 2017 6:26 AM in response to Wayne Contello In response to Wayne Contello

Adding the other option SGII highlighted:

enter the date in a cell (let's say cell A1), then in another cell enter the formula

=A1+"8d"


or

= A1 + 8


or

=A1 +DURATION(0,8)


note... the Duration() function takes many arguments.

DURATION(weeks,days,hours,minutes,seconds,milliseconds)


since I really only wanted to provide days, I must include "weeks" which proceeds the argument "days". All the arguments after day, however, are not necessary, so I left them off and they default to the value zero. The equivalent would be:


DURATION(0,8,0,0,0,0)

Dec 13, 2017 6:26 AM

Reply Helpful
User profile for user: ninyota

Question: How to add a number (ie. 8) to a date to output a date +8 days from starting date?