Thread: how to convert a column of numbers (monthdayyear) into dates?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default how to convert a column of numbers (monthdayyear) into dates?
On Tue, 15 Aug 2006 10:37:02 -0700, wsucougar
wrote:

At issue is some numbers are 7 digits and some 8 (ie 7012006 or 10012006).
None of my attempts resulted in excel recognizing as valid dates.

Here's one method:

=DATE(MOD(A1,10^4),INT(A1/10^6),MOD(INT(A1/10^4),100))


--ron
Reply With QuoteReply With Quote