So I have a column of cells that displays both the date and the time. i would like to extract just the date and put it into another column, but not the time. This could be because I want to use this information for further processing (maybe use it in a vlookup). Here is the best way to do it. https://www.youtube.com/watch?v=WXspXhYOjFI <br /><center><hr/> <img src="http://magicmonktutorials.com/images/logo_medium.jpg"><br /> <b>Mathematics & Digital Technologies Education</b><br /> <b>Videos, quizzes, and other learning resources</b><br /> Eddie the Magic Monk has 16 years teaching experience as a high school teacher in Australia. He will explain things to you in the simplest way possible to help you fully understand high school mathematics and computer science concepts. <br /> Eddie began his tutorial channel on Youtube in 2012. His videos have been well received all over the world and now has 22+ million views! He sees the benefit in multidisciplinary learning hence his tutorials cover topics ranging from maths to dance. <br /> <hr/> </center>
| author | magicmonk |
|---|---|
| permlink | microsoft-excel-tutorial-how-to-extract-just-the-date-from-date-time-cell |
| category | hive-122108 |
| json_metadata | {"app":"peakd/2020.10.3","format":"markdown","tags":["education","technology","palnet","stemsocial"],"image":["http://magicmonktutorials.com/images/logo_medium.jpg"]} |
| created | 2020-10-16 10:34:21 |
| last_update | 2020-10-16 10:34:21 |
| depth | 0 |
| children | 2 |
| last_payout | 2020-10-23 10:34:21 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 5.292 HBD |
| curator_payout_value | 3.978 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 1,070 |
| author_reputation | 957,815,405,281,744 |
| root_title | "Microsoft Excel Tutorial - How to extract just the Date from Date/Time cell" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,126,999 |
| net_rshares | 38,774,083,978,418 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| tuck-fheman | 0 | 740,757,574 | 3.25% | ||
| drifter1 | 0 | 1,166,345,874 | 3.25% | ||
| team | 0 | 146,720,294,772 | 20% | ||
| chris4210 | 0 | 12,407,171,152 | 3.25% | ||
| scalextrix | 0 | 1,693,411,933 | 3.25% | ||
| eric-boucher | 0 | 14,173,151,107 | 3.25% | ||
| thecryptodrive | 0 | 18,531,408,988 | 1.3% | ||
| mammasitta | 0 | 1,829,289,905 | 0.23% | ||
| good-karma | 0 | 30,252,887,487 | 2.33% | ||
| matt-a | 0 | 627,951,151 | 1.5% | ||
| ausbitbank | 0 | 718,120,428,660 | 25% | ||
| diana.catherine | 0 | 774,363,058 | 3.25% | ||
| krystle | 0 | 25,609,665,264 | 20% | ||
| fiveboringgames | 0 | 405,895,289,276 | 100% | ||
| deanliu | 0 | 3,721,313,419,502 | 100% | ||
| joshglen | 0 | 711,551,939 | 6.5% | ||
| pipokinha | 0 | 49,884,598,758 | 100% | ||
| magicmonk | 0 | 2,813,824,993,133 | 100% | ||
| psygambler | 0 | 604,575,621 | 3.25% | ||
| djennyfloro | 0 | 1,348,116,701 | 10% | ||
| kpine | 0 | 2,354,597,882,742 | 10% | ||
| hanshotfirst | 0 | 2,629,445,786,364 | 50% | ||
| lordvader | 0 | 971,562,261,998 | 100% | ||
| azizbd | 0 | 14,340,965,610 | 10% | ||
| lemouth | 0 | 182,279,069,906 | 10% | ||
| charlie777pt | 0 | 1,883,670,894 | 5% | ||
| alaqrab | 0 | 3,901,347,516 | 3.25% | ||
| uwelang | 0 | 35,027,968,707 | 3.25% | ||
| holoz0r | 0 | 7,719,870,642 | 9.75% | ||
| tfeldman | 0 | 5,323,487,064 | 3.25% | ||
| seckorama | 0 | 3,012,153,378 | 1.95% | ||
| lk666 | 0 | 3,123,797,844 | 3.25% | ||
| cnfund | 0 | 807,249,245 | 3.25% | ||
| michelle.gent | 0 | 1,297,923,986 | 1.3% | ||
| alishi | 0 | 36,516,004,735 | 50% | ||
| curie | 0 | 1,280,470,918,152 | 6.5% | ||
| modernzorker | 0 | 2,980,084,895 | 4.54% | ||
| reddust | 0 | 9,835,203,753 | 1.95% | ||
| techslut | 0 | 138,007,612,389 | 25% | ||
| giantbear | 0 | 95,949,636,445 | 100% | ||
| dashfit | 0 | 668,151,119 | 3.25% | ||
| tristancarax | 0 | 7,375,894,354 | 3.25% | ||
| zorg67 | 0 | 589,739,744 | 100% | ||
| sweetpea | 0 | 7,811,770,239 | 50% | ||
| edb | 0 | 794,187,950 | 0.65% | ||
| esteemapp | 0 | 39,393,532,917 | 2.32% | ||
| yadamaniart | 0 | 2,222,138,407 | 3.25% | ||
| apsu | 0 | 4,105,474,674 | 2.27% | ||
| valth | 0 | 874,927,024 | 3.25% | ||
| lastminuteman | 0 | 1,619,381,118 | 2.27% | ||
| driptorchpress | 0 | 3,058,089,457 | 3.25% | ||
| mauriciozoch | 0 | 508,116,822 | 3.25% | ||
| tarazkp | 0 | 2,708,509,950,347 | 50% | ||
| steemitboard | 0 | 4,824,336,916 | 2% | ||
| ambyr00 | 0 | 5,385,550,075 | 0.97% | ||
| theregularguy | 0 | 27,662,284,906 | 100% | ||
| steemiteducation | 0 | 517,531,489,258 | 100% | ||
| dhimmel | 0 | 143,262,644,870 | 2.27% | ||
| damla | 0 | 1,507,729,981 | 3.25% | ||
| chasmic-cosm | 0 | 819,675,102 | 3.25% | ||
| bloom | 0 | 15,432,104,476 | 3.25% | ||
| federacion45 | 0 | 11,240,806,890 | 3.25% | ||
| gamersclassified | 0 | 7,278,788,413 | 7.5% | ||
| mikepedro | 0 | 1,744,163,836 | 25% | ||
| jagged | 0 | 1,218,802,673 | 1.3% | ||
| roomservice | 0 | 161,360,705,895 | 3.25% | ||
| world-travel-pro | 0 | 85,344,636,691 | 20% | ||
| gohba.handcrafts | 0 | 6,423,339,502 | 7% | ||
| urs | 0 | 30,131,655,426 | 50% | ||
| sustainablyyours | 0 | 2,729,143,507 | 3.25% | ||
| erick1 | 0 | 1,341,599,623 | 3.25% | ||
| scooter77 | 0 | 5,141,726,706 | 25% | ||
| yehey | 0 | 71,047,239,770 | 6.5% | ||
| freetissues | 0 | 1,293,931,010 | 3.25% | ||
| cindycam | 0 | 4,933,656,924 | 25% | ||
| deisip67 | 0 | 1,606,095,611 | 10% | ||
| schoolforsdg4 | 0 | 9,448,080,678 | 5% | ||
| roseri | 0 | 5,094,731,076 | 50% | ||
| zerotoone | 0 | 1,308,777,003 | 3.25% | ||
| bearone | 0 | 49,399,369,189 | 15% | ||
| kalinka | 0 | 1,262,997,481 | 3.25% | ||
| mahdiyari | 0 | 43,581,446,739 | 6.5% | ||
| aboutyourbiz | 0 | 1,297,861,615 | 6.5% | ||
| derosnec | 0 | 709,036,915 | 3.25% | ||
| teamaustralia | 0 | 9,345,789,108 | 40% | ||
| oscarcede | 0 | 3,807,729,886 | 20% | ||
| centerlink | 0 | 230,996,040,073 | 50% | ||
| lasocia | 0 | 1,339,885,411 | 50% | ||
| ghostgtr | 0 | 2,146,935,257 | 20% | ||
| jayna | 0 | 2,157,296,097 | 0.65% | ||
| ew-and-patterns | 0 | 181,015,443,192 | 9% | ||
| hhayweaver | 0 | 2,370,682,286 | 3.25% | ||
| guchtere | 0 | 680,376,577 | 3.25% | ||
| wesphilbin | 0 | 1,682,283,001 | 4% | ||
| affiedalfayed | 0 | 4,815,269,708 | 40% | ||
| gunthertopp | 0 | 26,051,351,274 | 0.52% | ||
| pipiczech | 0 | 1,355,914,643 | 3.25% | ||
| pisolutionsmru | 0 | 901,916,342 | 3.25% | ||
| benedict08 | 0 | 210,758,529,414 | 100% | ||
| susanli3769 | 0 | 352,294,411,701 | 100% | ||
| edkarnie | 0 | 331,848,336,264 | 100% | ||
| flatman | 0 | 4,981,279,422 | 6.5% | ||
| allcapsonezero | 0 | 661,912,289 | 3.25% | ||
| minnowbooster | 0 | 123,051,719,297 | 1.3% | ||
| lugina | 0 | 1,330,476,306,102 | 100% | ||
| travelgirl | 0 | 98,028,413,088 | 60% | ||
| steemwizards | 0 | 72,157,186,444 | 100% | ||
| stayoutoftherz | 0 | 110,738,025,866 | 3.25% | ||
| jimshorts | 0 | 9,477,350,128 | 100% | ||
| investingpennies | 0 | 18,072,912,229 | 6.5% | ||
| onethousandwords | 0 | 1,024,668,586 | 25% | ||
| redrica | 0 | 3,743,844,881 | 3.25% | ||
| horpey | 0 | 78,499,668,190 | 100% | ||
| syedumair | 0 | 741,837,194,000 | 100% | ||
| tanyaschutte | 0 | 2,616,337,245 | 50% | ||
| appleskie | 0 | 1,283,462,556 | 4.54% | ||
| chrisdavidphoto | 0 | 8,799,845,882 | 15% | ||
| guada1 | 0 | 2,497,196,507 | 50% | ||
| pearlumie | 0 | 581,137,988 | 3.25% | ||
| betterthanhome | 0 | 22,138,405,199 | 6.5% | ||
| revo | 0 | 27,845,814,066 | 6.5% | ||
| munawar1235 | 0 | 434,369,937,760 | 100% | ||
| nerdnews | 0 | 17,159,696,100 | 100% | ||
| mulletwang | 0 | 70,947,592,416 | 35% | ||
| mrsquiggle | 0 | 299,434,954,998 | 100% | ||
| stickchumpion | 0 | 1,234,310,443 | 3.25% | ||
| webcoop | 0 | 3,370,933,535 | 25% | ||
| thelordsharvest | 0 | 11,180,248,855 | 6.5% | ||
| kimzwarch | 0 | 11,193,996,003 | 4% | ||
| olusolaemmanuel | 0 | 994,183,299 | 4.54% | ||
| massivevibration | 0 | 34,969,755,648 | 30% | ||
| vera-vaders-ea | 0 | 9,228,710,322 | 100% | ||
| holbein81 | 0 | 65,550,923,619 | 5.52% | ||
| trevorpetrie | 0 | 2,749,784,249 | 3.25% | ||
| torico | 0 | 1,549,546,918 | 2.14% | ||
| masterwu | 0 | 1,716,626,541 | 15% | ||
| yangoldberg | 0 | 8,693,659,849 | 6.5% | ||
| june0620 | 0 | 611,562,132,590 | 100% | ||
| karaoke1850 | 0 | 46,699,295,026 | 100% | ||
| minnowpowerup | 0 | 1,486,882,689 | 3.25% | ||
| revisesociology | 0 | 9,299,033,111 | 0.65% | ||
| cryptononymous | 0 | 2,020,271,886 | 3.25% | ||
| litzney | 0 | 566,484,887 | 50% | ||
| upme | 0 | 3,350,326,720 | 3.25% | ||
| gotgame | 0 | 695,794,466 | 3.25% | ||
| braveboat | 0 | 2,727,016,043 | 8% | ||
| jlsplatts | 0 | 9,307,359,654 | 1% | ||
| meno | 0 | 63,686,702,060 | 3.25% | ||
| buttcoins | 0 | 4,762,697,734 | 1.3% | ||
| toocurious | 0 | 292,011,186 | 3.25% | ||
| hanggggbeeee | 0 | 1,170,387,586 | 3.25% | ||
| esteem.app | 0 | 655,254,803 | 2.32% | ||
| fatkat | 0 | 1,740,305,706 | 3.24% | ||
| stevejhuggett | 0 | 10,226,277,709 | 20% | ||
| peaceandwar | 0 | 1,028,595,623 | 3.25% | ||
| marcoriccardi | 0 | 697,357,420 | 6.5% | ||
| long888 | 0 | 49,399,036,877 | 100% | ||
| tazbaz | 0 | 621,216,688 | 3.25% | ||
| japanguide | 0 | 1,801,320,469 | 60% | ||
| teacherspet | 0 | 22,813,799,532 | 100% | ||
| battebilly | 0 | 822,191,524 | 3.25% | ||
| notb4mycoffee | 0 | 53,446,490,147 | 100% | ||
| silverwhale | 0 | 24,208,861,972 | 90% | ||
| alvinauh | 0 | 37,884,948,653 | 30% | ||
| lays | 0 | 1,830,978,163 | 3.25% | ||
| amritadeva | 0 | 1,862,969,041 | 3.25% | ||
| postpromoter | 0 | 317,807,489,432 | 6.5% | ||
| faizarfatria | 0 | 564,911,293 | 3.24% | ||
| diverse | 0 | 8,938,184,922 | 3.25% | ||
| omstavan | 0 | 8,169,277,774 | 100% | ||
| bluefinstudios | 0 | 1,152,632,597 | 1.95% | ||
| steveconnor | 0 | 4,107,300,681 | 3.25% | ||
| sankysanket18 | 0 | 13,213,082,498 | 6.5% | ||
| thevillan | 0 | 1,530,576,596 | 2.5% | ||
| misterbob | 0 | 912,470,373 | 50% | ||
| lordnigel | 0 | 1,708,526,470 | 27% | ||
| teukurival | 0 | 539,789,552 | 3.25% | ||
| jeffandhisguitar | 0 | 10,708,162,478 | 50% | ||
| drmake | 0 | 3,716,772,328 | 3.25% | ||
| travoved | 0 | 996,649,295 | 50% | ||
| cataluz | 0 | 2,189,752,963 | 3.25% | ||
| blue-pencil | 0 | 15,192,871,009 | 100% | ||
| danile666 | 0 | 8,127,020,269 | 6.17% | ||
| pechichemena | 0 | 807,171,718 | 1.3% | ||
| afifa | 0 | 839,550,395 | 10% | ||
| mhm-philippines | 0 | 2,258,019,422 | 3.25% | ||
| hanzappedfirst | 0 | 75,233,598,473 | 100% | ||
| skycae | 0 | 821,469,464 | 6.5% | ||
| itchyfeetdonica | 0 | 465,200,229,443 | 100% | ||
| weirdnews | 0 | 8,518,481,902 | 100% | ||
| cryptwo | 0 | 5,347,034,456 | 45% | ||
| kenadis | 0 | 842,973,393 | 3.25% | ||
| madridbg | 0 | 691,487,045 | 5% | ||
| marcolino76 | 0 | 1,341,851,783 | 3.25% | ||
| onemedia | 0 | 662,811,931 | 6.5% | ||
| kamchore | 0 | 123,904,344,309 | 100% | ||
| punchline | 0 | 259,334,410,065 | 100% | ||
| bellaian | 0 | 1,608,818,243 | 70% | ||
| danaedwards | 0 | 848,436,339 | 6.5% | ||
| dechastre | 0 | 665,213,659 | 3.25% | ||
| phgnomo | 0 | 824,657,343 | 3.25% | ||
| gordon92 | 0 | 779,102,100 | 3.25% | ||
| stahlberg | 0 | 1,499,905,696 | 3.25% | ||
| jordan.white306 | 0 | 564,086,679 | 25% | ||
| gabrielatravels | 0 | 2,318,609,645 | 1.3% | ||
| cordeta | 0 | 1,077,185,567 | 6.5% | ||
| reizak | 0 | 585,462,728 | 2.6% | ||
| carn | 0 | 1,674,479,923 | 6.5% | ||
| korinkrafting | 0 | 835,110,859 | 22.5% | ||
| fineartnow | 0 | 3,628,120,127 | 3.25% | ||
| hijosdelhombre | 0 | 3,057,081,609 | 3.25% | ||
| bengy | 0 | 1,884,587,244 | 1.5% | ||
| steemvault | 0 | 1,950,529,414 | 6.5% | ||
| steem4all | 0 | 1,273,206,422 | 3.25% | ||
| communitybank | 0 | 8,616,653,112 | 6.5% | ||
| fun2learn | 0 | 1,287,153,480 | 3% | ||
| shinedojo | 0 | 806,342,702 | 6.5% | ||
| bennettitalia | 0 | 1,551,894,385 | 1.62% | ||
| utube | 0 | 3,543,820,774 | 6.5% | ||
| heidimarie | 0 | 39,353,919,749 | 10% | ||
| steveblucher | 0 | 6,044,330,798 | 50% | ||
| womenempowerment | 0 | 924,557,362 | 5% | ||
| bec-on-the-block | 0 | 1,402,212,621 | 25% | ||
| mermaidvampire | 0 | 16,603,368,741 | 45% | ||
| kylo-ren | 0 | 7,939,279,126 | 100% | ||
| terrylovejoy | 0 | 9,313,703,980 | 20% | ||
| jimcustodio | 0 | 1,847,962,725 | 50% | ||
| neneandy | 0 | 7,496,684,770 | 6.5% | ||
| pab.ink | 0 | 1,715,853,763 | 3.25% | ||
| sportscontest | 0 | 2,381,899,180 | 6.5% | ||
| giddyupngo | 0 | 1,057,762,436 | 3.25% | ||
| videosteemit | 0 | 5,276,418,362 | 6.5% | ||
| mashiliyanage | 0 | 1,510,441,430 | 50% | ||
| pandasquad | 0 | 611,601,589 | 6.5% | ||
| atongis | 0 | 1,732,583,915,132 | 100% | ||
| leoumesh | 0 | 1,131,128,715 | 6.5% | ||
| mproxima | 0 | 1,410,376,816 | 3.25% | ||
| fantasycrypto | 0 | 5,585,175,255 | 3.25% | ||
| didic | 0 | 2,959,605,471 | 3.25% | ||
| operahoser | 0 | 592,853,323 | 0.97% | ||
| beverages | 0 | 12,076,030,487 | 3.25% | ||
| sweetkathy | 0 | 2,194,492,660 | 100% | ||
| nwjordan | 0 | 989,590,721 | 6.5% | ||
| sandracabrera | 0 | 3,058,291,269 | 50% | ||
| themonkeyzuelans | 0 | 647,730,079 | 3.25% | ||
| verhp11 | 0 | 1,543,672,048 | 1% | ||
| oghie | 0 | 1,127,743,322 | 50% | ||
| photohunt | 0 | 8,417,155,207 | 6.5% | ||
| ejlo3310 | 0 | 2,850,146,216 | 50% | ||
| chungsu1 | 0 | 6,483,740,087 | 3.25% | ||
| atomcollector | 0 | 618,951,338 | 1.62% | ||
| stk-g | 0 | 1,571,474,500 | 6.5% | ||
| ruth-elise | 0 | 539,800,340 | 30% | ||
| sargewhale | 0 | 831,923,681 | 100% | ||
| lightflares | 0 | 6,947,965,445 | 3.25% | ||
| citimillz | 0 | 7,058,152,938 | 3.25% | ||
| doikao | 0 | 40,185,435,862 | 6.5% | ||
| kitalee | 0 | 3,293,129,680 | 3.25% | ||
| forester-joe | 0 | 696,525,024 | 1.5% | ||
| chrislybear | 0 | 813,109,906 | 3.25% | ||
| vicesrus | 0 | 9,910,174,579 | 3.25% | ||
| zipporah | 0 | 3,281,567,630 | 1.3% | ||
| hadley4 | 0 | 1,009,186,494 | 6.5% | ||
| idkpdx | 0 | 191,419,607 | 3.25% | ||
| superlotto | 0 | 11,001,644,581 | 6.5% | ||
| norwegianbikeman | 0 | 5,959,320,536 | 5% | ||
| positiveninja | 0 | 8,639,489,758 | 25% | ||
| miroslavrc | 0 | 2,439,388,906 | 1.62% | ||
| bscrypto | 0 | 11,877,810,647 | 3.25% | ||
| evlachsblog | 0 | 6,540,225,035 | 25% | ||
| vonaurolacu | 0 | 1,606,098,935 | 3.25% | ||
| movingman | 0 | 2,206,836,165 | 20% | ||
| proto26 | 0 | 875,979,852 | 6.5% | ||
| scottcbusiness | 0 | 1,194,786,404 | 3.25% | ||
| rodrigocassio | 0 | 885,846,296 | 100% | ||
| bil.prag | 0 | 1,096,770,723 | 0.32% | ||
| vcclothing | 0 | 25,260,951,686 | 40% | ||
| sapphic | 0 | 5,239,247,289 | 25% | ||
| supersoju | 0 | 46,020,942,519 | 20% | ||
| sanderjansenart | 0 | 4,141,290,503 | 3.25% | ||
| vittoriozuccala | 0 | 2,001,129,269 | 3.25% | ||
| qberry | 0 | 3,662,692,859 | 3.25% | ||
| lesmouths-travel | 0 | 765,310,544 | 10% | ||
| stmdev | 0 | 393,289,532 | 10% | ||
| broncofan99 | 0 | 23,661,311,975 | 20% | ||
| rambutan.art | 0 | 3,357,769,226 | 6.5% | ||
| greddyforce | 0 | 2,555,417,016 | 2.4% | ||
| flyerchen | 0 | 545,779,726 | 3.25% | ||
| braaiboy | 0 | 11,056,983,996 | 4.87% | ||
| blainjones | 0 | 1,592,855,296 | 1.3% | ||
| bobaphet | 0 | 3,250,162,381 | 10% | ||
| melbourneswest | 0 | 14,506,745,594 | 25% | ||
| terrybogan | 0 | 2,722,491,991 | 15% | ||
| mumma-monza | 0 | 5,805,166,251 | 25% | ||
| c0wtschpotato | 0 | 627,098,623 | 3.25% | ||
| cryptoslicex | 0 | 675,473,739 | 25% | ||
| misia1979 | 0 | 851,306,437 | 3.25% | ||
| quochuy | 0 | 162,579,569,075 | 10.01% | ||
| lorenzopistolesi | 0 | 1,034,922,802 | 3.25% | ||
| julialee66 | 0 | 823,841,979,214 | 6.5% | ||
| andrewharland | 0 | 3,320,173,515 | 6.5% | ||
| mariusfebruary | 0 | 17,163,143,845 | 2.6% | ||
| davidcentenor | 0 | 887,805,827 | 3.25% | ||
| outtheshellvlog | 0 | 957,031,920 | 3.25% | ||
| el-dee-are-es | 0 | 451,001,890,157 | 100% | ||
| srijana-gurung | 0 | 1,522,856,061 | 3.25% | ||
| indigoocean | 0 | 12,779,142,857 | 3.25% | ||
| lifeofryan | 0 | 4,238,429,690 | 25% | ||
| incubot | 0 | 6,826,446,393 | 4.87% | ||
| apteacher | 0 | 2,479,334,377 | 20% | ||
| primersion | 0 | 118,031,840,089 | 50% | ||
| veteranforcrypto | 0 | 2,032,445,670 | 1.3% | ||
| playdice | 0 | 898,886,582 | 2.43% | ||
| gwilberiol | 0 | 9,685,784,316 | 5.85% | ||
| netzisde | 0 | 8,566,634,079 | 6.5% | ||
| edanya | 0 | 815,504,631 | 3.25% | ||
| aceaeterna | 0 | 5,076,042,458 | 50% | ||
| minerthreat | 0 | 1,083,995,044 | 3.25% | ||
| nateaguila | 0 | 187,830,670,400 | 5% | ||
| stevenwood | 0 | 1,951,300,557 | 2.16% | ||
| enforcer48 | 0 | 124,625,127,508 | 15% | ||
| motherofalegend | 0 | 810,126,953 | 3.25% | ||
| musicvoter2 | 0 | 4,574,437,747 | 1% | ||
| vincy | 0 | 4,529,289,186 | 10% | ||
| pialejoana | 0 | 970,119,726 | 3.25% | ||
| wolfofnostreet | 0 | 834,556,062 | 3.25% | ||
| gravii4 | 0 | 6,756,770,579 | 100% | ||
| uche-nna | 0 | 6,953,518,890 | 5.2% | ||
| myfreebtc | 0 | 1,076,308,685 | 5.2% | ||
| niouton | 0 | 5,450,801,834 | 20% | ||
| lightcaptured | 0 | 2,828,708,850 | 1.3% | ||
| schroders | 0 | 2,623,046,492 | 1.95% | ||
| dzoji | 0 | 1,118,543,611 | 6.5% | ||
| citizendog | 0 | 8,145,748,349 | 6.5% | ||
| cryptocopy | 0 | 590,137,023 | 3.25% | ||
| longer | 0 | 782,658,423 | 1.62% | ||
| blewitt | 0 | 8,013,000,788 | 0.32% | ||
| leilanyarevalo | 0 | 539,989,182 | 30% | ||
| mrnightmare89 | 0 | 587,764,598 | 1.3% | ||
| ilovecryptopl | 0 | 1,082,949,505 | 5.2% | ||
| mindblast | 0 | 7,868,523,137 | 3.25% | ||
| bflanagin | 0 | 5,791,434,381 | 3.25% | ||
| sadbear | 0 | 1,105,754,192 | 3.25% | ||
| call-me-howie | 0 | 598,779,342 | 3.25% | ||
| goblinknackers | 0 | 155,492,943,198 | 4% | ||
| deividluchi | 0 | 1,183,190,079 | 25% | ||
| honeycup-waters | 0 | 588,474,057 | 3.25% | ||
| yaelg | 0 | 1,006,492,123 | 1.95% | ||
| pvinny69 | 0 | 1,801,808,116 | 6.5% | ||
| vegemitekid | 0 | 21,656,926,661 | 20% | ||
| kylealex | 0 | 5,388,567,517 | 10% | ||
| orlandogonzalez | 0 | 4,132,152,138 | 25% | ||
| minimining | 0 | 1,726,576,031 | 3.25% | ||
| spoke | 0 | 11,490,609,402 | 5.2% | ||
| edu-venezuela | 0 | 130,466,333,112 | 100% | ||
| hanshotfirst-sm | 0 | 8,406,199,319 | 100% | ||
| marcocasario | 0 | 12,613,005,695 | 3.25% | ||
| oakshieldholding | 0 | 427,470,066 | 100% | ||
| palasatenea | 0 | 567,950,980 | 3.25% | ||
| knightbjj | 0 | 932,626,958 | 4.87% | ||
| the.success.club | 0 | 2,692,357,433 | 3.25% | ||
| chickenmeat | 0 | 1,355,111,079 | 3.25% | ||
| tommyl33 | 0 | 867,784,218 | 3.25% | ||
| gungunkrishu | 0 | 1,627,367,567,546 | 100% | ||
| dubignyp | 0 | 1,085,504,094 | 20% | ||
| brianoflondon | 0 | 11,563,863,645 | 0.97% | ||
| reverseacid | 0 | 641,546,409 | 3.25% | ||
| sanjeev021 | 0 | 1,572,471,528 | 100% | ||
| esthersanchez | 0 | 4,288,174,104 | 40% | ||
| florino | 0 | 820,447,387 | 15% | ||
| alphaccino.art | 0 | 18,135,368,637 | 25% | ||
| alvin0617 | 0 | 579,553,437 | 3.25% | ||
| adalger | 0 | 30,134,443,067 | 2% | ||
| solarphasing | 0 | 547,718,009 | 5% | ||
| cakemonster | 0 | 8,360,493,317 | 6.5% | ||
| cesarisaad | 0 | 535,153,825 | 30% | ||
| healthdear | 0 | 16,064,509,457 | 100% | ||
| autobodhi | 0 | 636,728,907 | 6.5% | ||
| morarnagringa | 0 | 1,206,078,708 | 100% | ||
| robmojo | 0 | 727,672,053 | 0.32% | ||
| double-negative | 0 | 552,283,711 | 20% | ||
| bit4bit | 0 | 7,357,180,101 | 6.5% | ||
| currentxchange | 0 | 41,326,601,107 | 50% | ||
| jacuzzi | 0 | 1,358,212,717 | 3.25% | ||
| vaultec | 0 | 4,043,414,100 | 12% | ||
| steemstorage | 0 | 9,699,972,993 | 6.5% | ||
| steemegg | 0 | 611,151,610 | 1.62% | ||
| juanbg | 0 | 1,399,783,013 | 10% | ||
| crowdwitness | 0 | 7,564,860,667 | 5% | ||
| baasdebeer | 0 | 649,108,571 | 4.87% | ||
| hairgistix | 0 | 3,292,171,170 | 3.25% | ||
| rem-steem | 0 | 2,182,819,663 | 1.3% | ||
| chocolatelover | 0 | 2,560,875,188 | 60% | ||
| limka | 0 | 719,097,083 | 100% | ||
| dfacademy | 0 | 109,547,774,671 | 100% | ||
| bluemaskman | 0 | 636,484,007 | 3.25% | ||
| abbenay | 0 | 2,753,350,679 | 12.5% | ||
| cryptological | 0 | 875,505,365 | 3.25% | ||
| afternoondrinks | 0 | 666,093,275 | 4.87% | ||
| raynen | 0 | 3,985,163,295 | 100% | ||
| src3 | 0 | 39,232,877,746 | 50% | ||
| lefty619 | 0 | 3,155,460,664 | 6.5% | ||
| cryptofiloz | 0 | 13,438,046,954 | 6.5% | ||
| jackramsey | 0 | 914,782,784 | 4.54% | ||
| ambifokus | 0 | 751,811,619 | 0.97% | ||
| elements5 | 0 | 1,746,171,106 | 3.25% | ||
| epicdice | 0 | 14,688,868,799 | 1.95% | ||
| iamsaray | 0 | 1,040,334,965 | 3.25% | ||
| deeanndmathews | 0 | 1,963,444,008 | 3.25% | ||
| robibasa | 0 | 12,463,309,551 | 10% | ||
| scholaris | 0 | 4,574,201,506 | 1.62% | ||
| socialbot | 0 | 1,790,714,151 | 5% | ||
| fractalfrank | 0 | 9,526,708,301 | 3.25% | ||
| likwid | 0 | 486,216,543 | 0.06% | ||
| plankton.token | 0 | 25,938,929,365 | 30% | ||
| tggr | 0 | 1,196,826,486 | 3% | ||
| iamjohn | 0 | 1,832,154,501 | 25% | ||
| titan-c | 0 | 2,378,706,801 | 6.5% | ||
| shimozurdo | 0 | 2,112,070,102 | 3.25% | ||
| mind.force | 0 | 1,003,640,649 | 1.62% | ||
| penpals | 0 | 1,138,408,054 | 100% | ||
| bedazzled | 0 | 20,339,581,530 | 100% | ||
| freddio.sport | 0 | 9,317,876,953 | 50% | ||
| babytarazkp | 0 | 7,846,564,813 | 85% | ||
| abh12345.stem | 0 | 723,681,044 | 100% | ||
| thranax | 0 | 4,301,986,328 | 10% | ||
| nazer | 0 | 650,843,227 | 3.25% | ||
| oniemaniego | 0 | 1,017,877,981 | 3.25% | ||
| urtrailer | 0 | 1,214,818,322 | 0.25% | ||
| stemd | 0 | 330,947,344 | 100% | ||
| joshmania | 0 | 2,284,189,325 | 1.62% | ||
| writertales | 0 | 1,067,724,523 | 6.5% | ||
| herzinfuck | 0 | 2,921,165,547 | 3.25% | ||
| dmoonfire | 0 | 38,014,826,882 | 71% | ||
| yggdrasil.laguna | 0 | 298,816,546 | 60% | ||
| ibt-survival | 0 | 39,325,608,299 | 10% | ||
| bella.bear | 0 | 12,610,537,703 | 25% | ||
| yourtop3 | 0 | 10,368,809,589 | 2.6% | ||
| pavelsku | 0 | 347,251,932 | 3.25% | ||
| roamingsparrow | 0 | 6,334,645,807 | 4.87% | ||
| gloriaolar | 0 | 2,302,916,324 | 3.25% | ||
| xxxxxxxxxxxxxxxx | 0 | 1,150,329,860 | 3.25% | ||
| mehmetfix | 0 | 6,478,733,800 | 8% | ||
| theisacoin | 0 | 1,099,065,641 | 10% | ||
| almightymelon | 0 | 1,193,088,959 | 3.25% | ||
| educationhive | 0 | 53,746,263,260 | 100% | ||
| education-hive | 0 | 10,587,456,379 | 100% | ||
| hornetsnest | 0 | 5,613,589,474 | 3.25% | ||
| thepeakstudio | 0 | 799,604,763 | 3.25% | ||
| hive.consultant | 0 | 5,292,470,193 | 5.2% | ||
| manwojciech | 0 | 504,892,180 | 6.5% | ||
| visionaer3003 | 0 | 1,384,914,899,173 | 45% | ||
| peterpanpan | 0 | 1,294,807,111 | 1.3% | ||
| the100 | 0 | 3,918,511,484 | 3.25% | ||
| hiveonboard | 0 | 4,380,033,790 | 3.25% | ||
| ninnu | 0 | 1,032,887,265 | 0.23% | ||
| kiemis | 0 | 1,875,117,139 | 0.48% | ||
| kiemurainen | 0 | 3,982,214,986 | 2.73% | ||
| ecency | 0 | 134,655,361,986 | 2.31% | ||
| nockzonk | 0 | 914,455,262 | 10% | ||
| localgrower | 0 | 11,609,400,333 | 20% | ||
| aquarius.academy | 0 | 46,787,181,716 | 100% | ||
| dna.org | 0 | 26,468,754,745 | 20% | ||
| hatschi0773 | 0 | 883,175,712,714 | 37.5% | ||
| ecency.stats | 0 | 205,390,226 | 2.32% | ||
| zartisht | 0 | 416,580,997,852 | 100% | ||
| hivecur2 | 0 | 33,646,172,315 | 5% | ||
| spirall | 0 | 620,925,580 | 3.25% | ||
| dagobert007 | 0 | 1,829,739,587,714 | 50% | ||
| jpvmoney | 0 | 1,212,782,489 | 3.25% | ||
| chucknun | 0 | 4,748,004,769 | 1.62% | ||
| boneym | 0 | 10,125,409,834 | 44.5% | ||
| cosplay.hadr | 0 | 675,523,534 | 3.25% | ||
| hadrgames | 0 | 692,798,417 | 3.25% |
Thanks for using **Ecency**! <br>Your post has been **voted** as a part of [Encouragement program](https://ecency.com/esteem/@good-karma/encouragement-program-continues-82eafcd10a299). Keep up the good work! <br>Dear readers, follow and support this author, Install Android: https://android.ecency.com, iOS: https://ios.ecency.com mobile app or desktop app for Windows, Mac, Linux: https://desktop.ecency.com<br>Learn more: https://ecency.com <br>Join our discord: https://discord.me/ecency
| author | ecency |
|---|---|
| permlink | re-20201016t123821146z |
| category | hive-122108 |
| json_metadata | {"tags":["ecency"],"app":"ecency/3.0.5-welcome","format":"markdown+html"} |
| created | 2020-10-16 10:38:21 |
| last_update | 2020-10-16 10:38:21 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-10-23 10:38:21 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 490 |
| author_reputation | 549,956,868,457,730 |
| root_title | "Microsoft Excel Tutorial - How to extract just the Date from Date/Time cell" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,127,028 |
| net_rshares | 0 |
Congratulations @magicmonk! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) : <table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@magicmonk/upvotes.png?202010171635"></td><td>You distributed more than 27000 upvotes. Your next target is to reach 28000 upvotes.</td></tr> </table> <sub>_You can view your badges on [your board](https://hivebuzz.me/@magicmonk) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>
| author | hivebuzz |
|---|---|
| permlink | hivebuzz-notify-magicmonk-20201017t170432000z |
| category | hive-122108 |
| json_metadata | {"image":["http://hivebuzz.me/notify.t6.png"]} |
| created | 2020-10-17 17:04:30 |
| last_update | 2020-10-17 17:04:30 |
| depth | 1 |
| children | 0 |
| last_payout | 2020-10-24 17:04:30 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 634 |
| author_reputation | 368,217,316,501,288 |
| root_title | "Microsoft Excel Tutorial - How to extract just the Date from Date/Time cell" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 100,142,624 |
| net_rshares | 0 |
hiveblocks