LinkBack URL
About LinkBacks
I'm trying to convert Manufacturing Lot # 03180940702 to April 04 2018 in any format date. The numbers to read off of this are as follows
03
18 - year (2018)
094 julian date (April 04 2018)
0702
Does anyone know what formula I can use?
I'm trying to convert Manufacturing Lot # 03180940702 to April 04 2018 in any format date. The numbers to read off of this are as follows
03
18 - year (2018)
094 julian date (April 04 2018)
0702
Does anyone know what formula I can use?
Last edited by jalcocer1990; 07-17-2018 at 03:07 PM. Reason: correction a typo in lot #
Does this help?
https://www.extendoffice.com/documen...r-date.html#a1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The problem is that I have more digits than what that article shows. I'm trying to type in that code and have a formula populate the date off of that long set of #'s.
I get that 03 = monthOriginally Posted by jalcocer1990
I get that 18 = year
but how on earth does 090 become April 04?
And I assume you dont need 4702?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That was a typo on my end. Julian date should've been 094 for April 04. Thanks I'll correct that and use more tags!
OK so does the 09 part even mean anything regarding the date?
your sample...
03180940702
day?
03180940702
Year?
03180940702
Month?
If so, what would 12 Dec 2018 look like?
The only #'s that read the date is 18 for the year and 094 (julian date)
Free-Sample-Julian-Calendar.jpeg
Try this:
=DATE(20&MID(A1,3,2),1,1)+A5-1
oh, duh LOL
=DATEVALUE("1/1/"&MID(A1,2,2)+2000)+MID(A1,4,3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks