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

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

متابعة

I want to calculate days between two dates, which formula will help me?

user-image
تم إضافة السؤال من قبل Shabbir Hussain , Assistant Registrar , LUMS
تاريخ النشر: 2013/09/25
Zafar Iqbal
من قبل Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Mr. Shabbir following is the answer of your question, indeed a very simple and good question

 

Days between two dates : use (-) formula

Week days between two dates : use (networkdays) formula

Mohammed Ahmed Hamza Abdelate
من قبل Mohammed Ahmed Hamza Abdelate , Deputy HR Manager , Projects Supply Company - PSC

Days between two dates : use (-) formula

Week days between two dates : use (networkdays) formula

 

Osama Alia
من قبل Osama Alia , Freelance consultation (Financial Management, Banking) , Freelance CFO

You can do it with excell by doing the following:

1. enter old date at one cell.

2. enter the newest date at another cell.

3. minus the old date from the newest date and you will get the difference in dates.

ابراهيم محمد محمود شهاب الدين
من قبل ابراهيم محمد محمود شهاب الدين , محاسب , انتجريتد سوليوشن للأستثمارات العقاريه وادارة المشروعات

date

Tony Semaan
من قبل Tony Semaan , BI Specialist - Technical Consultant , Sword Group

use the datediff function

dafaallah Awadelkarim Talha Shaaldin   CMA
من قبل dafaallah Awadelkarim Talha Shaaldin CMA , المدير المالي والاداري , شركة عقد الثريا للتجارة و شركة تحت الشمس الرياضية

you can use exel sheet to calculate te difference between two days

write the beging day in the cell and write the ending day in the near cell  by the same date formula and subtacts one from two you can find the result by days

reham Al-jarrah
من قبل reham Al-jarrah , سكرتارية , مؤسسة الزكاة الامريكية

you can use datedif formula  to calculate days between tow date 

=datedif(beging day,ending day,"d")

this formula calculate all date 

but  

you can use NETWORKDAYS.INTL formula to calculate just worke days between tow date 

NETWORKDAYS.INTL(Start Date,End Date,[Weekend],[Holidays])

not this formula in Excel2010

 

Mohamed Mahmoud
من قبل Mohamed Mahmoud , Accountant , Tourism Company for tourism and tourism Transportation

  you can type the latest date first under it type the first date like this formula : Year / Month / Day . and   calculate the difference between them . between year first then month then days 

Gul Shujah CICP
من قبل Gul Shujah CICP , Credit Controller , Johnson Controls

Deduct current date from the previous date

Format will be .  Month / Date / Year 

12/31/2013 -12/31/2012 =365 Days  

 

Abdulrehman Mohammed
من قبل Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company

Use Datedif formula, this is excel's hidden formula. =datedif(<date1>,<date2>,"D") 

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