Excellent
Visha wrote on December 31, 1969 19: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 19: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 19: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 19: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 19: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 19: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 19: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 19:00 EST |
| Very simple. Use NUMTOINDTEXT |
PROBLEM WITH DATES
Luna wrote on December 31, 1969 19: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! |
Writing Excel Macros with VBA, 2nd Edition
