Skip to main content
Solved

Struggling with a formula for counting difference between dates

  • August 19, 2019
  • 3 replies
  • 41 views
M

Hello,

I’m trying to make a formula that counts the difference between start date and end date, however if end date is blank calculate the difference between start date, and current date.

Sorry if it sounds simple, i’m very new to airtable!

Thanks
Matt

Best answer by JonathanBowen

Hi @Matthew_Grundy - try this:

IF(
{End Date}, 
DATETIME_DIFF({End Date}, {Start Date}, 'days'), 
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)

JB

3 replies

JonathanBowen
Forum|alt.badge.img+18
  • JonathanBowen
  • Inspiring
  • Answer
  • August 19, 2019

Hi @Matthew_Grundy - try this:

IF(
{End Date}, 
DATETIME_DIFF({End Date}, {Start Date}, 'days'), 
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)

JB

M
Justin_Barrett
Justin_Barrett
Forum|alt.badge.img+21

Hi @Matthew_Grundy - try this:

IF(
{End Date}, 
DATETIME_DIFF({End Date}, {Start Date}, 'days'), 
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)

JB


Here’s another way to write it, putting the IF function inside a single DATETIME_DIFF:

DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, "days")
M
M
  • Matthew_Grundy
  • Author
  • New Participant
  • August 20, 2019

Hi @Matthew_Grundy - try this:

IF(
{End Date}, 
DATETIME_DIFF({End Date}, {Start Date}, 'days'), 
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)

JB


Works perfectly!
thank you for your help.

Matt

Terms & ConditionsAccessibility statement