Excel: text conversion to date format -


i convert text - apr 7 2017 date format on excel spread sheet. there formula might it? have tried format cell date format did not change cell properties. thank suggestions

with data in a1, in cell enter:

=datevalue(lookup(left(a1,3),{"apr","aug","dec","feb","jan","jul","jun","mar","may","nov","oct","sep"},{4,8,12,2,1,7,6,3,5,11,10,9}) & mid(substitute(a1," ","/"),4,99))

enter image description here

an alternative:

=datevalue(trim(mid(a1,5,2)) & "-" & left(a1,3) & "-" & right(a1,4))

Comments

Post a Comment

Popular posts from this blog

python - Best design pattern for collection of objects -

i have following architecture: +-----------------+ | collection | | | | | | | | | +-----------------+ | ^ | | create() | | | | v | getitem(b) +------------+ | | item | | | | | | +------+ | | +------------+ a class managing collection of items, creates items. , these items may need other items collection. the actual code in python, , collection passes parameter created item . see it, bad practice. improvement can see pass few functions of collection needed item , instead of whole instance. for example: class collection: getitem(self, id): ... createitem(self, id): item = item(id, self) # <-- pass self ... class item: __init__(self, id, col): ... col.getite...
Read more

android - IllegalStateException: Cannot call this method while RecyclerView is computing a layout or scrolling -

i trying remove item recyclerview , error. java.lang.illegalstateexception: cannot call method while recyclerview computing layout or scrolling i using notifydatasetchanged() . how can solve this? here adapter code public class listadapters extends recyclerview.adapter<listadapters.myviewholder> { public arraylist<string> tvdatalist; context c; int pos; listadapters.myviewholder myviewholder; private layoutinflater layoutinflater; int[] arr; public class myviewholder extends recyclerview.viewholder implements view.onclicklistener { public edittext edttxt; public checkbox cb; public myviewholder(view view) { super(view); edttxt = (edittext) view.findviewbyid(r.id.edttxt); cb = (checkbox) view.findviewbyid(r.id.cb); } @override public void onclick(view v) { } } public listadapters(context c, arraylist<string> tvdatali...
Read more

go - serving up pdfs using golang -

Image
just wondering if guys can code. it works serving images not pdf brochure. in advance func main(){ http.handlefunc("/", func(w http.responsewriter, r *http.request){ filename := "/var/www/filedipenser/brochure.pdf" streampdfbytes, err := ioutil.readfile( filename ) if err != nil { fmt.println(err) os.exit(1) } b := bytes.newbuffer(streampdfbytes) w.header().set("content-type", "application/pdf") if _, err := b.writeto(w); err != nil { fmt.fprintf(w, "%s", err) } w.write([]byte("pdf generated")) }) err := http.listenandserve(":4111", nil) if err != nil { log.fatal("listenandserve: ", err) fmt.println(err) } } the code bit inefficient appears working. however, pdf viewers might sensitive extraneous output adding end of http response stream...
Read more