Count the number of days from start date to end date

Closed
Posts
2
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I want to count the number of days from start date to end date. ie. 1/2/15 - 1/4/15 is 3 days.

1 reply

Posts
2
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015

Hello, i think i figured it out =sum(1+startdate-enddate). If there is a better way, please let me know.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
You dont need to do sum
=startdate - enddate +1