Thread: How do I create a date format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How do I create a date format
If the typed value is in A1, then in B1:

=DATE(2000+RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))

--
Gary''s Student - gsnu200779
Reply With QuoteReply With Quote