Calculating Differences Between Dates

» Calculating Differences Between Dates

VERSIONS: All Microsoft Excel Versions

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

Rate this tip



1	2	3	4	5

RATING: 3.42
VIEWS: 105036

Email Tip

Print Tip

Add to My Tips

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

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!

Sponsors:

Book Store:

VIEW ALL BOOKS

Recommended Books:

Related MS EXCEL TIPS:

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.