Total Days | Airtable Community

I need a column to calculate the total days- formula being ENDDATE minus STARTDATE plus 1. Any suggestions? I can get the datetime_diff, but that is days between not total days.

Thank you!!

Page 1 / 1

You would just add +1 to the end of your formula like this:

DATETIME_DIFF({End Date},{Start Date},'days') +1

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey @LWSEA!

Scott’s solution above is correct.
Just FYI you might also be interested in taking a look at the WORKDAY_DIFF() formula. Might or might not apply

For more information on Date Functions you can check out this Article.

Thank you @ScottWorld. I had been putting the +1 inside the parentheses. With your help, it is now working. Thank you!!

I am brand new to Airtable, so just learning as I go for now.

Appreciate the help.

You’re welcome! Glad I could help!