Count the number of days from start date to end date

Closed
Melvac Posts 2 Registration date Tuesday October 20, 2015 Status Member Last seen October 20, 2015 - Oct 20, 2015 at 11:39 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 04:19 PM
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

Melvac Posts 2 Registration date Tuesday October 20, 2015 Status Member Last seen October 20, 2015
Oct 20, 2015 at 11:44 AM
Hello, i think i figured it out =sum(1+startdate-enddate). If there is a better way, please let me know.
-1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 20, 2015 at 04:19 PM
You dont need to do sum
=startdate - enddate +1
0