Adding an extra day to datediff | Airtable Community

I’m running a datediff formula but it’s not displaying the result I’m expecting. I would like the output to include the day itself.

In other words if I’ve got a date range from 28 April to 30 April, for our purposes this is a 3 day event. DateDiff gives 2 days though.

DATETIME_DIFF

({Date ended},{Date started},

‘days’)&" days"

Any thoughts?

Page 1 / 1

You can add 1 to the difference

(DATETIME_DIFF(

  {Date ended},

  {Date started},

  ‘days’

) + 1)

&" days"

Utter brilliance! Thank you so much.

Sign up