how do i get Excel to calculate # of years worked? 1

[cmpgeek]

hey yall, i have looked through the FAQs, but can not find one that helps me... what i am trying to do is set up a cell that will take the date entered in a separate cell, subtract it from today's date, and then show the # of years worked.

example:
cell B1 will hold date of hire information: 11/17/97
i want cell D1 to take the information entered into B1 and subtract it from today's date and then show that the person has worked in that department 6+ years. does that make sense? it seems simple enough, but i dont know the formulas needed.

any help would be greatly appreciated... thanks

my vital stats: Crystal 8.5 / Oracle database / Windows XP...
... always in a state of ... inspiring to some day experience ...

 

[carrr]

Check out these resources:

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

http://www.contextures.com/xlfaqDat.html

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

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[cmpgeek]

thanks carrr! the first link had just what i wanted...

also, thank you for posting all three links... i am always looking for help sites to bookmark...



my vital stats: Crystal 8.5 / Oracle database / Windows XP...
... always in a state of ... inspiring to some day experience ...

 

[carrr]

You bet

"'Tis an ill wind that blows no minds." - Malaclypse the Younger