 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006Converting Day Numbers to Dates...
I'm using XL2003. For manufacturing purposes, products are stamped with a serial number that includes the day of manufacture, represented by the day number, i.e. January 1st = 001, 1st February = 032 and so on. Each new year begins again at 001. Is there a quick way to convert this 3-digit day number to an actual date? Thanks in advance, Amanda Nel post news:F6EAA57F-5618-415B-8902-0BE953455AD0@microsoft.com *Birmangirl* ha scritto: > I'm using XL2003. For manufacturing purposes, products are stamped > with a serial number that includes the day of manufacture, [quoted text clipped - 3 lines] > date? Thanks in advance, > Amanda Hi Amanda, =DATE(YEAR(TODAY()),1,VALUE(D14)) In D14 you have your 3 digits day.  SignatureHope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy Nel post news:ed0OzbslGHA.1676@TK2MSFTNGP05.phx.gbl *Franz Verga* ha scritto: > Nel post news:F6EAA57F-5618-415B-8902-0BE953455AD0@microsoft.com > *Birmangirl* ha scritto: [quoted text clipped - 12 lines] > > In D14 you have your 3 digits day. Because if you open next year the file with 2006 data, the dates would change, you can change the above formula n this way: =DATE(D12,1,VALUE(D14)) where in D12 you have to type 2006. SignatureHope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy Ciao Franz - this works perfectly! Amanda > Nel post news:F6EAA57F-5618-415B-8902-0BE953455AD0@microsoft.com > *Birmangirl* ha scritto: [quoted text clipped - 12 lines] > > In D14 you have your 3 digits day. shorter than my offering but it also works without the value, even if text =DATE(YEAR(TODAY()),1,A1) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Nel post news:F6EAA57F-5618-415B-8902-0BE953455AD0@microsoft.com > *Birmangirl* ha scritto: [quoted text clipped - 12 lines] > > In D14 you have your 3 digits day. Nel post news:ugSb$jslGHA.1204@TK2MSFTNGP02.phx.gbl *Don Guillett* ha scritto: > shorter than my offering but it also works without the value, even if > text =DATE(YEAR(TODAY()),1,A1) Yes, I didn't think that also the DATE function makes the conversion from text to value.. SignatureCiao Franz Verga from Italy try this formula or a macro to do it for you. =DATEVALUE(12&"/"&31&"/"&YEAR(TODAY()))-365+A1 SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > I'm using XL2003. For manufacturing purposes, products are stamped with a > serial number that includes the day of manufacture, represented by the day [quoted text clipped - 4 lines] > Thanks in advance, > Amanda |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.