Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Calculating Differences Between Dates

CATEGORY: Excel Dates



To calculate the difference between dates:

Use the DATEDIF function. The results of the calculation are displayed as days, full months, and full years.

Note: The DATEDIF function is not included in the Insert Function dialog box.
Screenshot // Calculating Differences Between Dates

Calculating Differences Between Dates
Rate this tip
12 34 5
  RATING: 3.42
  VIEWS: 105036
Excellent
Visha wrote on December 31, 1969 18:00 EST
Hi, this tip is really useful. I got result in few seconds. description of the function and the example shows exactly what we want.

Thk u so much

Inverse of this function
Dennis wrote on December 31, 1969 18:00 EST
Is it possible to get the inverse of this done?
I have a sheet in which i have a project divided into component parts. I know how much time each part will take. Accordingly the timelines have been assigned. if and when any one date is changed, i don't want to have to change all the timelines again. just adding the days required to each date will not be enough since i have no way of excluding saturdays and sundays. is there any way i can do that in excel 2000?
Negative Months
KL wrote on December 31, 1969 18:00 EST
I would like to calculate Baseline finish vs Actual Finish on a project. Currently, I have the calculation:

=IF(F4<E4,(DATEDIF(F4,E4,"m")),(DATEDIF(F4,E4,"m")*(-1)))

This is not working. The main problem I have is that if it finishes early it will not return a negative # of months.

Is this possible to automate?
Negative Months
KL wrote on December 31, 1969 18:00 EST
I would like to calculate Baseline finish vs Actual Finish on a project. Currently, I have the calculation:

=IF(F4<E4,(DATEDIF(F4,E4,"m")),(DATEDIF(F4,E4,"m")*(-1)))

This is not working. The main problem I have is that if it finishes early it will not return a negative # of months.

Is this possible to automate?
After a long period of searching
Mahesh Guptha wrote on December 31, 1969 18:00 EST
I am searching to know the date formulas and difference between dates from the past one month. Now i got this. Thank you.
mahesh_guptha@sify.com
Converting Rs.(Number) to Words
Mukesh K Agarwal wrote on December 31, 1969 18:00 EST
Hi,

Is ther any formula to convert number to text Ex: Rs.100/- to Rs.One Hundred .I tried using BAHTEXT but the result is displayed in Thai.

Pl mail back to mukesh_ccu@hotmail.com
networkdays
snigdha wrote on December 31, 1969 18:00 EST
networkdays function calculates the present day as the working day. Is there a way around it ??
Converting Rs.(Number) to Words
KK wrote on December 31, 1969 18:00 EST
Very simple. Use NUMTOINDTEXT
PROBLEM WITH DATES
Luna wrote on December 31, 1969 18:00 EST
ANYONE KNOWS A WAY TO CALCULATE THE TRANSCURRED DAYS IN A PROJECT THAT DEPENDS IN A DURATION OF A PROCESS AND THE START/END DATE?

THANKS!



REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation