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!!
Solved
Total Days
+2Best answer by ScottWorld
You would just add +1 to the end of your formula like this:
DATETIME_DIFF({End Date},{Start Date},'days') +1Hope 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
+35You would just add +1 to the end of your formula like this:
DATETIME_DIFF({End Date},{Start Date},'days') +1Hope 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
+28Hey
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.
+2Thank you
I am brand new to Airtable, so just learning as I go for now.
Appreciate the help.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.