Thread: how calculate the date someone had to be born to have a specific a
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how calculate the date someone had to be born to have a specific a
=DATE(YEAR(TODAY())-A1,MONTH(TODAY()),DAY(TODAY()))

--
Gary's Student
gsnu200705


"AAlvarez" wrote:


I am trying o build a formula to calculate the the date someone need to be
born in order to have certaing age.
Reply With QuoteReply With Quote