Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculating with dates
want to calculate the difference between two dates
and necesarry to see the result separated by years / months / days but dont know how?? for example: 20/05/2005 - 10/03/1990 = 15 years/ 2months/ 11days thanks for your attention!! PS using excel 2000 |
#2
|
|||
|
|||
See:
http://www.cpearson.com/excel/datedif.htm Biff "DzEK" wrote in message ... want to calculate the difference between two dates and necesarry to see the result separated by years / months / days but dont know how?? for example: 20/05/2005 - 10/03/1990 = 15 years/ 2months/ 11days thanks for your attention!! PS using excel 2000 |
#3
|
|||
|
|||
On Wed, 29 Jun 2005 22:59:45 +0200, "DzEK" wrote:
want to calculate the difference between two dates and necesarry to see the result separated by years / months / days but dont know how?? for example: 20/05/2005 - 10/03/1990 = 15 years/ 2months/ 11days thanks for your attention!! PS using excel 2000 Since all months and years do not have the same number of days, you will have to accept some approximations, or else define exactly what you mean by a "month" and a "year". Take a look at the DATEDIF function. I believe Excel 2000 may be the only Excel version in which it is documented. But see also http://www.cpearson.com/excel/datedif.htm --ron |
#4
|
|||
|
|||
the point is to calculate the somebodies working period in firm!
i know when somebody arrive and left the firm. so i want "automatically" know how many years, months and dates did someb. spend on work... http://www.cpearson.com/excel/datedif.htm is excellent link, but always get the error when copy/paste in my workbook. don't know what to do!! can you explain me how to solve the problem, step by step, please from the beginning, :) mean, where what, syntax etc. many thans |
#5
|
|||
|
|||
On Thu, 30 Jun 2005 22:43:25 +0200, "DzEK" wrote:
the point is to calculate the somebodies working period in firm! i know when somebody arrive and left the firm. so i want "automatically" know how many years, months and dates did someb. spend on work... http://www.cpearson.com/excel/datedif.htm is excellent link, but always get the error when copy/paste in my workbook. don't know what to do!! can you explain me how to solve the problem, step by step, please from the beginning, :) mean, where what, syntax etc. many thans As I wrote, years and months are not precise. One year may have 365 days, or 366 days. One month may have 28, 29, 30 or 31 days. So if you want to know EXACTLY how long someone has worked, you can use days or weeks. So the formula would be StartDate-EndDate (and format the result as General) If you want to know approximately, in years, months and days, you can use the DATEDIF function: =DATEDIF(StartDate,EndDate,"y")& " years, "& DATEDIF(StartDate,EndDate,"ym")&" Months, and "& DATEDIF(StartDate,EndDate,"md") & " Days" But this formula, although usually reasonably close, can give some strange results depending on your StartDate and EndDate. For example: StartDate: 1/31/2004 EndDate: 3/1/2005 Result: 1 years, 1 Months, and -2 Days So if you have better definitions of how you want to define month and year, let us know. --ron |
#6
|
|||
|
|||
hi ron,
well, my problem with calculating dates is the same like calculating a person's age.... and i'm very satisfied with formiula you send me link! but, when i copy formula from webpage and paste in my document, always get the error message and don't know what to do.. thanks to your attention PS This moment had idea, check formula and i solve the problem!!! ( replaced , with ; and the formula works...) many, many thanks to you |
#7
|
|||
|
|||
On Fri, 1 Jul 2005 22:35:08 +0200, "DzEK" wrote:
hi ron, well, my problem with calculating dates is the same like calculating a person's age.... and i'm very satisfied with formiula you send me link! but, when i copy formula from webpage and paste in my document, always get the error message and don't know what to do.. thanks to your attention PS This moment had idea, check formula and i solve the problem!!! ( replaced , with ; and the formula works...) many, many thanks to you I'm glad the formula is satisfactory, and that you were able to get it to work. The separator issue is one common problem in copying formulas from these newsgroups. Best, --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
calculating service dates | Excel Worksheet Functions | |||
Using imported Query & Calculating Dates | Excel Worksheet Functions |