Thread: how to convert 12/10/1970 to years/months/days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default how to convert 12/10/1970 to years/months/days
Hi

With date in A1
=Year(A1)
=Month(A1)
=Day(A1)

--
Regards

Roger Govier


"doctor who golf" wrote in
message ...
can any one help me to covert 12/10/1970 to years/months/days


Reply With QuoteReply With Quote