Count the number of days from start date to end date

Closed

Melvac Posts 2 Registration date Tuesday 20 October 2015 Status Member Last seen 20 October 2015 - 20 Oct 2015 à 11:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Oct 2015 à 16:19

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.

How to calculate number of days in excel including start and end date
Excel add days to date - Guide
Formula to calculate vat in excel - Guide
How to change date format in excel - Guide
Number to words in excel - Guide
Count number of occurrences in excel - Guide

1 response

Réponse 1 / 1

Melvac Posts 2 Registration date Tuesday 20 October 2015 Status Member Last seen 20 October 2015
20 Oct 2015 à 11:44

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 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Oct 2015 à 16:19

You dont need to do sum
=startdate - enddate +1

Similar discussions

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

Convert number to spelling

HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS

calculating fuel surcharge

Similar discussions

Subscribe To Our Newsletter!