Thread: Dates = years old
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brurobiney Brurobiney is offline
external usenet poster
  
Posts: 11
Default Dates = years old
Got it. Thank you Toppers!!

"Toppers" wrote:

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