Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to years
Is there anyway of converting a date to the amount of years. I have
employees years started posted and I want to convert to years worked with the company. Thanks Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to years
Use the DATEDIF command.
=DATEDIF(start_date, TODAY(),"y") See www.cpearson.com/excel/datedif.htm for more info about DATEDIF. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Savage" wrote in message ... Is there anyway of converting a date to the amount of years. I have employees years started posted and I want to convert to years worked with the company. Thanks Kevin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to years
Hi
If the date is a recognised Excel date, you can simply deduct the date from today's date and format the result as yy. Hope this helps. Andy. "Savage" wrote in message ... Is there anyway of converting a date to the amount of years. I have employees years started posted and I want to convert to years worked with the company. Thanks Kevin |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to years
Hi, try this: =DATEDIF(A1,TODAY(),"y") # years you can also use: "m" - months "d" - days "ym" - year months "yd" - year days HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=494468 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to years
If you only have the starting years and want a rough estimate (calendar
years) you can use =YEAR(TODAY())-A1 where A1 holds the start year -- Regards, Peo Sjoblom (No private emails please) "Savage" wrote in message ... Is there anyway of converting a date to the amount of years. I have employees years started posted and I want to convert to years worked with the company. Thanks Kevin |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date to years
thanks, works great
"pinmaster" wrote: Hi, try this: =DATEDIF(A1,TODAY(),"y") # years you can also use: "m" - months "d" - days "ym" - year months "yd" - year days HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=494468 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Math Problem | Excel Worksheet Functions | |||
Calculat years married or age of someone on today's date | Excel Worksheet Functions | |||
date and time | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |