calculating with dates

[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

 

[Biff]

See:

http://www.cpearson.com/excel/datedif.htm

Biff

 

[Ron Rosenfeld]

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

 

[DzEK]

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

 

[Ron Rosenfeld]

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

 

[DzEK]

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

 

[Ron Rosenfeld]

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