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

Formula to determine whole days of start/end

Topic Labels: Formulas
567 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a start date (example 12/25/18)
I have an end date (example 12/26/18)

I need to find out how many days that is total.

I used this:

DATETIME_DIFF(Date1,Date2,‘days’)

and it came up with 1 (26-25=1, however that is accurate as it needs to be 2, since it is the 25th & the 26th.

2 Replies 2

add + 1 to the end of your formula, after the parenthesis. Or, have your date fields include a time and have the DATETIME_DIFF calculate the difference in 'hours', then divide that formula by 24.

Thank you for the help!!