Thread: How do I "extract" birthyear from a date field?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default How do I "extract" birthyear from a date field?
=YEAR(A1)

--
Regards,
Dave


"cp" wrote:

I have a column of birthdates in date format but need a column that contains
just the 2-digit birthyear, not the full date.
Reply With QuoteReply With Quote