How to count the days between 2 dates in excel 2010?

First of all enter the start date and end date.

Then take difference.

For Example:

type in A1 cell (start date)

type in A2 cell (end date)

type in A3 cell (=A2-A1) and press enter

There is a lesser known function in Excel called "DATEDIF(start_date,end_date,unit)" where start date and end date are two dates you want to refer to and the "unit" the duration type you want returned. In this question, since you want to know the number of days between two dates, the unit shall be "d" which denotes to days. One can also use "m" for months and "y" for years. These abbreviations should be written in double quotes because those are text values.

Caution: This function does not appear in standard excel formulae due to unknown reasons.

Open new spreadsheet

Write dates in cell A1 and another in cell B1

write a formula in C cell : =Datedif(A1,B2,"d") and enter 

your will get the counts of days between two dates

determine the staring date and the end date. enter A1 (starting  date) A2 end date.. lie this

=A1-A2 then enter 

Enter start and end date in the cells and find the difference

First of all enter the start date and end date.

Then t

To get the result we just have to use formula ENDDATE- STARTDATE. We can also use the DATE function for the same.

such as knowing the days between today and the coming month .just go write in cell the date of the coming month . then select another cell and write=(today function) then press enter , there will appear an unknown date , press format cell and choose number instead of date . and the number of days will appear to you.

Start date and end date.. and it should be like month/date/year

A1-start date, A2 end date and A3 cell =A1-A2 result

A1-start date, A2 end date and A3 cell =A1-A2 result

Make sure that the two dates are entered in date format and not text. Then simply subtract the latter date from the earlier date so that the difference is positive.