Calculating the difference between dates

[ultra_xcyter]

I have an employee who started working for me on 08/20/1996 and I wan
to know how long that has been up through 06/23/04. Is there a formul
to calculate the difference between the two dates that include
month/day/year

 

[RagDyer]

Use the Datediff function.
If you have XL2k, it's in the Help.
If you have any other version, try Chip Pearson's web page:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


message I have an employee who started working for me on 08/20/1996 and I want
to know how long that has been up through 06/23/04. Is there a formula
to calculate the difference between the two dates that includes
month/day/year?

 

[Paul B]

Ultra, have a look here

http://www.cpearson.com/excel/DateTimeWS.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[Harald Staff]

Hi

Simply subtract the later from the earlier, format as number. The result is
in days. Divide by 7 to get the result in weeks. Months and years vary in
lenght, so accurate measures are somewhere between difficult and
meaningless. But try this anyway:
http://www.cpearson.com/excel/datedif.htm

HTH. Best wishes Harald

 

[RA5300S]

*I have an employee who started working for me on 08/20/1996 and
want to know how long that has been up through 06/23/04. Is there
formula to calculate the difference between the two dates tha
includes month/day/year? *

Try Lifespan Age Calculator Macro for Excel.
http://www.anzweres.org/free/lifespan/

There are detailed installation instructions and you don't need t
understand any of the internal workings. If you want to understand th
internal working you are free to look. Just follow the installatio
instructions and use the function like you would any built in function