Dear Excel Forum Members and Experts,
I am trying to extract Year from dates in a row. I am using the following code, however I am getting 1905 as year in each cell.
Please look at this and help if possible. I have made some changes to comply to the RULE 3 of the Forum
Thanks
My Dates are in ROW6 and extracting Year in ROW1
Please Login or Register to view this content.
Last edited by shahamat; 10-26-2017 at 09:48 PM. Reason: Rule 3 of our Forum RULES
the code provides no information to why you are getting the results you are getting
suggest you provide example data along with the code as well
Last edited by humdingaling; 10-26-2017 at 11:02 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This line extracts the year alreadyPlease Login or Register to view this content.
then this line converts the year into "date" formatPlease Login or Register to view this content.
all this can go away
just change the format to general for row 1 and it should display the correct yearPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks