Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age at a certain date
I have to determine the age of an employee on the day they start employment
and the day they end employment. I have their birthdate in Column A, date of hire in Column B, date of termination in Column C. I have too many names to do this by hand. What is the formula for calculating the Age on their Date of Hire (Column D) and the Age on their Date of Termination (Column E). Any help would be appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age at a certain date
Use the DATEDIF function, described here on Chip Pearson's site:
http://www.cpearson.com/excel/datedif.aspx (it is not described in Excel Help, other than in XL 2000). Hope this helps. Pete On Apr 23, 1:16*pm, HelpDeb wrote: I have to determine the age of an employee on the day they start employment and the day they end employment. *I have their birthdate in Column A, date of hire in Column B, date of termination in Column C. *I have too many names to do this by hand. *What is the formula for calculating the Age on their Date of Hire (Column D) and the Age on their Date of Termination (Column E). *Any help would be appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age at a certain date
Hi,
Put this In d1 =DATEDIF($A$1,B1,"y") Drag to E1 Mike "HelpDeb" wrote: I have to determine the age of an employee on the day they start employment and the day they end employment. I have their birthdate in Column A, date of hire in Column B, date of termination in Column C. I have too many names to do this by hand. What is the formula for calculating the Age on their Date of Hire (Column D) and the Age on their Date of Termination (Column E). Any help would be appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age at a certain date
That shouls
d have been =DATEDIF($A1,B1,"y") Now it can be dragged down "Mike H" wrote: Hi, Put this In d1 =DATEDIF($A$1,B1,"y") Drag to E1 Mike "HelpDeb" wrote: I have to determine the age of an employee on the day they start employment and the day they end employment. I have their birthdate in Column A, date of hire in Column B, date of termination in Column C. I have too many names to do this by hand. What is the formula for calculating the Age on their Date of Hire (Column D) and the Age on their Date of Termination (Column E). Any help would be appreciated! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age at a certain date
That is so cool! Thanks for your help. You're the man!
"Mike H" wrote: Hi, Put this In d1 =DATEDIF($A$1,B1,"y") Drag to E1 Mike "HelpDeb" wrote: I have to determine the age of an employee on the day they start employment and the day they end employment. I have their birthdate in Column A, date of hire in Column B, date of termination in Column C. I have too many names to do this by hand. What is the formula for calculating the Age on their Date of Hire (Column D) and the Age on their Date of Termination (Column E). Any help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating using a date | Excel Discussion (Misc queries) | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Calculating due date? | Excel Worksheet Functions |