In Apple Numbers, how can I calculate a difference between two dates?

automation applescript spreadsheet iwork
MedicineMan picture MedicineMan · Sep 28, 2011 · Viewed 10.5k times · Source

I have a spreadsheet with data in Apple Numbers. I have a column of dates, and I would like to create a second column which displays the difference in number of days between the two dates.

Example:

Date..................Difference

May 1, 2011......NA

May 3, 2011......2

May 8, 2011......5

My first inclination is applescript, but perhaps applescript might be overkill for this task.

In any case, please fwd as needed.

Answer

Philip Regan picture Philip Regan · Sep 28, 2011

Applescript and Automator is definitely overkill. All you need to do given two dates is reference the cells in an equation and Pages handles the rest. So, given...

    'A'                 'B'
'1' '2011 September 28' ''
'2' '2011 September 27' ''
'3' '2011 September 20' ''

...you only need to do then...

    'A'                 'B'
'1' '2011 September 28' ''
'2' '2011 September 27' '=A2-A1' --> gives "1d"
'3' '2011 September 20' '=A3-A1' --> gives "8d"

Related questions

How can I pass an argument to a PowerShell script?

There's a PowerShell script named itunesForward.ps1 that makes iTunes fast forward 30 seconds: $iTunes = New-Object -ComObject iTunes.Application if ($iTunes.playerstate -eq 1) { $iTunes.PlayerPosition = $iTunes.PlayerPosition + 30 } It is executed with a prompt line command: powershell.exe itunesForward.ps1 Is it …

Read More
Typing the Enter/Return key using Python and Selenium

I'm looking for a quick way to type the Enter or Return key in Selenium. Unfortunately, the form I'm trying to test (not my own code, so I can't modify) doesn't have a Submit button. When working with it manually, …

Read More
automatically execute an Excel macro on a cell change

How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my working code is: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("H5")) Is Nothing Then …

Read More