ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Ahmad Melhem , Low Current and KNX Engineer , Modern Times Technical Systems -MTTS Co
تاريخ النشر: 2016/02/09
Muhammad Qasim
من قبل Muhammad Qasim , Assistant Project Manager , University of Central Punjab

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.

Davinder Singh Davinder Singh
من قبل Davinder Singh Davinder Singh , Deputy Section Officer , Dayanand Medical College & Hospital, Ludhiana

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 

Kalpana Rani Seyadira
من قبل Kalpana Rani Seyadira , Sr. Hr professional , ALIQAN

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

مستخدم محذوف‎
من قبل مستخدم محذوف‎

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

samia kouadri
من قبل samia kouadri , Document control , Rowad Modern Engineering

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.

sudha perumal
من قبل sudha perumal , Accountant , Genxlead

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

Oussama OTMANI
من قبل Oussama OTMANI

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

 

Ruth Bartholomeusz
من قبل Ruth Bartholomeusz , Executive Management , MORE FROM BIZ

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.

 

المزيد من الأسئلة المماثلة