» Calculating Differences Between Dates

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

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?

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?

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?

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

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 function calculates the present day as the working day. Is there a way around it ??

Very simple. Use NUMTOINDTEXT

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!