Thread: Dates = years old
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Dates = years old
try:

=DATEDIF(J2,TODAY(),"y")

"Brurobiney" wrote:

Cell J2 has DOB - 1/4/1993
Cell K2 has AGE

How can I get K2 to insert age? (years only)
Reply With QuoteReply With Quote