Previous Topic Next Topic

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 4478 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.
Related:

1 response

Answer 1 / 1
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.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 20, 2015 at 04:19 PM
You dont need to do sum
=startdate - enddate +1

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response