Hello,
I am working on setting up a new date converter as were switching software and need to transfer numerous data sets. I am currently trying to convert a date from 00/0000 (which is currently acting as a number) to 00/00/0000. Any ideas? Thanks in advance for the help!
Last edited by RigbyDigby; 12-11-2019 at 07:17 PM. Reason: (Solved)
so, going from this... 00/0000 to this 00/00/0000, how is someone to know what those numbers represent? 00/0000
can you give an actual example of each number and are we to assume it will all be in excel?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I appreciate your comment, and apologize for the lack of context as it is my first time posting. I am using Microsoft Excel and for example I am trying to convert 12/2019 (today's date without the specific day) to 12/01/2019. So currently the 12/2019 is defined as a number, and I would like to convert a specific date from the original context of 00/0000 to 00/01/0000. Thanks again for the feedback!
this would be one way... =IF(LEN(A1)=7,DATEVALUE(LEFT(A1,2)&"/01/"&RIGHT(A1,4)),DATEVALUE(LEFT(A1,1)&"/01/"&RIGHT(A1,4)))
BUT, I don't know if when you have 9/2019 that it isn't 09/2019 instead of 9/2019. So that is why I added the LEN formula into the datevalue formula.
I have dropped a test excel in the comments here. The data set I am working with does not include a zero before a one as such (1/2019) - Which is the way its currently formatted. Although if the date was October of 2019 it would show up with 10/2019.
Last edited by RigbyDigby; 12-11-2019 at 07:17 PM.
=date(right(a2,4),--(left(a2,len(a2)-5)),1)
Ben Van Johnson
What do you mean by "is defined as a number"? What number? Is it 43800? If so, it is already the date you want and all you need to do is format the cell using the date format of your choice.Originally Posted by RigbyDigby
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks