Value Function

  • Thread starter Thread starter antmorano
  • Start date Start date
A

antmorano

I have a weird problem. When I bring data in from my AS/400 system
they come in like this: 440914- which is the date 9/14/1944. I used
the value formula to switch around the digits and add the slashes, but
I have ran into a problem.

This value: 250211- is being read as 2/11/2025- when it should be
2/11/1925.

This doesn't happen to all of them. Can someone please help me?

-Anthony Morano
Pension Intern.
 
Use the DATE() function to force selection to the correct century. With:
250211-
in A1, for formula:
=DATE(1900+LEFT(A1,2),MID(A1,3,2),MID(A1,5,2))
will return
2/11/1925
 
Back
Top