SharePoint List Formatting
Back to column formats
Column formattingSharePoint Online

Date Difference

This sample demonstrates calculating the difference between 2 dates. In this sample the age in years is calculated based on the date of birth and the date of death. This format could easily be adjusted to calculate a different unit of time (months, days, hours, minutes, etc.) by adjusting the multiplier.

Get this format View on GitHub

Shared by Chris Kent
Updated Oct 2, 2019

Date Difference formatting preview
Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

1 definition

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

Column formatting
Download JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=floor((Number([$Died])-Number([$Born]))/(1000*60*60*24*365))"
}
View sourceLink to this definitiondate-difference.json

From the contributor

How to use this sample

Summary

This sample demonstrates calculating the difference between 2 dates. In this sample the age in years is calculated based on the date of birth and the date of death. This format could easily be adjusted to calculate a different unit of time (months, days, hours, minutes, etc.) by adjusting the multiplier.

screenshot of the sample

View requirements

This format can be applied to any column, however it expects the following fields to be present in the view:

Type Internal Name Required
Date Born Yes
Date Died Yes

Sample

Solution Author(s)
date-difference.json Chris Kent

Version history

Version Date Comments
1.0 October 2, 2019 Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Additional notes