Excel numbers--

  • Thread starter Thread starter gnolamar
  • Start date Start date
G

gnolamar

I received this formula for changing regular unformatted
dates to a date field. =DATA(RIGHT(A1,4),LEFT(A1,1),MID
(A1,2,2)

This formula works great except for the dates for Sept-
Dec. Such as 12161995 this formula gives me the date of
1/21/1995. What is the RIGHT number instead of 4?

Thank you!
 
Try this amendment

=DATE(RIGHT(A1,4),LEFT(A1,IF(LEN(A1)=7,1,2)),MID(A1,IF(LEN(A1)=7,2,3),2))
 
I received this formula for changing regular unformatted
dates to a date field. =DATA(RIGHT(A1,4),LEFT(A1,1),MID
(A1,2,2)

This formula works great except for the dates for Sept-
Dec. Such as 12161995 this formula gives me the date of
1/21/1995. What is the RIGHT number instead of 4?

Thank you!
Click to expand...


Try this formula instead:

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


--ron
 
Back
Top