calculating with dates

  • Thread starter Thread starter DzEK
  • Start date Start date
D

DzEK

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
 
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
Click to expand...

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
 
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
 
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
Click to expand...

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
 
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
 
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
Click to expand...

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
 
Back
Top