Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Adding an extra day to datediff

Topic Labels: Formulas
Solved
Jump to Solution
315 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

You can add 1 to the difference

(DATETIME_DIFF(
  {Date ended},
  {Date started},
  ‘days’
) + 1)
&" days"

See Solution in Thread

2 Replies 2

You can add 1 to the difference

(DATETIME_DIFF(
  {Date ended},
  {Date started},
  ‘days’
) + 1)
&" days"

Utter brilliance! Thank you so much.