| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
