» Calculating Differences Between Dates
CATEGORY - Excel Dates
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Business Analysis with Microsoft Excel (2nd Edition)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Marketing Plan: A Handbook with Marketing Plan
Inverse of this function
Dennis
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
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
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
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
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
networkdays function calculates the present day as the working day. Is there a way around it ??
Converting Rs.(Number) to Words
KK
Very simple. Use NUMTOINDTEXT
PROBLEM WITH DATES
Luna
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!
Thk u so much