Time saving trick: Quick Convert Text to date in Excel

Hello Friends,
In this video you will learn how to a text to a date in excel. To do show we will not use any VBA for Excel formulas.
Watch the best infographics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert

[@KumarSingh-zc3iw]

Finally... my requirement completes here. Thanks dude for such a fantastic excel information.

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@user-bu5jv8di9n]

sir thank you vey much for video very informative and valuable in practical date format gives lot of trouble your explanation will solve the problem

[@timskinner5184]

Brilliant! Saved me re-writing 400+ cells, thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there

[@yatiraghuvanshi7753]

Thank you so much...much useful and short video

[@PKAnExcelExpert]

You are most welcome

[@AdnanMohmand]

Millions of thanks for resolving my issue.

[@smkumarphone]

Thank you so much. The was much helpfull for me.👍

[@PKAnExcelExpert]

Glad it helped!

[@salmafauziaazka]

ya Allah makasih berkat video ini aku ga nangis lagi😭 Its super helpful, thank you so much🥺❤

[@nithikasn]

Dear PK!
Kamal ye yaar! thank you for solving my issues. Text to column "MDY" function Delimited
AWESOME!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@iwantovani3727]

Thanks bro, it very helpful to resolve my problem. Greetings from Indonesia.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vaibhavdhanwate7182]

Solved my big problem. Very Helpful, Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rggamitgamit9299]

Thank u for saving my time and finally i present my sheet perfectly

[@PKAnExcelExpert]

Most welcome 😊

[@JigneshPatel]

Nice. Very good.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sanofamotivation]

Thank you it was very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@wstibbs1]

Thank you! Great help for my early morning frustration!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@skyblue2337]

Thank you for sharing this video, very helpful. Please continue sharing such informational videos. Thank you again.

[@AmitAgarwal1977]

Excellent Video

[@Ohmystarz1]

Helpful, thank you.

[@PKAnExcelExpert]

Most welcome

[@amazinggrace6927]

Thanks a lot, this saved me

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@leebalaila4760]

Thank you. This video helped me solve my date problem.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@smabdullahalmahmud8499]

Thank you so so mauch!

[@PKAnExcelExpert]

Thanks for watching

[@Manojkalkere]

Thank you very much. It is very helpful. It works great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@reshmagandhi7667]

Thank you so so so so so so so muchh.. you were really helpful !!

[@pinakimajumdar3788]

Thanks for sharing

[@PKAnExcelExpert]

Most welcome🙏

[@comnetcns1]

Great contents Sir, surely helping in day to day MIS analytics work, thanks for update us

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@marcelodelmastro8792]

Thank you so much!!!!! That will save me a lot of time!!

[@anjaneyulukodam9961]

Thanks alot for your kind explanation about the date format that was most useful in routain.
Good night sir,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@siaozam]

best ever advise! was a mystery to me for ages

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@anuppatel5807]

Thank you so much....
It solved my problem....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rubs63]

thank you, so much ...That was really very helpful !!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@zlumbers]

Thanks, this is what I'm looking for

[@PKAnExcelExpert]

Glad I could help

[@soc2rob]

Thank you! You saved me hours

[@PKAnExcelExpert]

Glad it helped!

[@neilbiggin]

This has been a huge help to me, many thanks.

[@PKAnExcelExpert]

Thank for your valuable feedback

[@venkatsubramanian9978]

Very usefull

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gercris70]

Thank you so so so so so so so muchh.. you were really helpful !! For me this was a life saver!!!!

[@PKAnExcelExpert]

Thanks for your appreciation. Please share it with your friends and colleagues whoever is needing this.

[@JofelTanAC]

Very Helpful. Thanks You so much.",

[@PKAnExcelExpert]

Most welcome🙏

[@FRANKWHITE1996]

great! thanks!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@syedabdullah5259]

Very nice

[@PKAnExcelExpert]

Thanks

[@rajeevgosavi4514]

Very well explained Sir. You have made life so easy.Thanks . We also request you to upload a video with downloadable worksheets to cover power query fully.

[@elvisjmartis]

Thank you so much. It was really helpfull

[@PKAnExcelExpert]

Glad to hear that!

[@mohie63]

Indeed one of the best tips ever, thanks :)

[@PKAnExcelExpert]

Thanks for your appreciation. Please share it with your friends and colleagues.

[@manojkrishnan8461]

Thank you so much

[@PKAnExcelExpert]

Thanks for watching

[@muthuraja6589]

Useful for me and our team mates. Thank you sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share this video with your team also.

[@muthuraja6589]

Sure sir

[@vijayfulwar6172]

Hi Priyendra sir,
This is really good and much helpful n real working environment. I am learning a lot by watching your videos. Thanks a lot for your videos and lnowledge sharing.... Everytime realize that there is so much to learn....

[@PKAnExcelExpert]

Thanks Vijay,
For your valuable feedback.

[@ikramcomputerzonemandani7116]

THANKS SIR

[@PKAnExcelExpert]

Most welcome

[@Dilsehandsome]

Thanks

[@PKAnExcelExpert]

Welcome

[@brandonchin6731]

Super helpful. Thanks a lot man!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vipinkumar-le7yf]

I, m also facing same problem since 1 month now my problem solved by this video

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@PawanYadav_the_professor]

THANKS !!!

[@PKAnExcelExpert]

Most Welcome.

[@pinxpillay134]

Thank you dear , thanks for showing a quick and easy way to fix the dates

[@jackjimenezpereda9252]

Excelente amigo. muchas gracias

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@anushkasampath1647]

Hi .Thank you very much for information. However, I want to ask you something other than this. Let say, different formats of date is included in a one coloumn in a large data sheet, what would we do to arrange it properly. For example first 20 rows as DMY order and then YMD.

[@stanislassembinelli1821]

Really helpful!! Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained

[@dileepmaurya5632]

Thanku so much sir for sharing this knowledge.
Sir I am changing 10.2.2021 this date and this date is in text
I want to change in date by excel macro.
Please help as soon as possible. 🙏🙏

[@andrejholasek7916]

thanks, it helped me a lot!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arunkumar-tt5wc]

Usefull video tq❤

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@muradalabsy2862]

Thank you you are my hero

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@dharmendrayadav-bw2gp]

Nice video sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashvinkallee143]

Similarly, please explain how to convert text to time.

[@dope3.142]

i love you bhai thanks

[@PKAnExcelExpert]

Most welcome

[@DineshMakwana7]

Hello Sir, very useful all videos, just need one information can we find date in excel sheet....

[@muslehuddinmuzammil3071]

I owe you a thumb up buddy,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@excelavon]

Very Nice Trick

[@jafarsadiq.a7481]

Thank you Sir

[@PKAnExcelExpert]

Thanks for watching

[@gobisekaran5102]

Tons of thank you for solving my issues. How to get age using excel in particular date that means as at 31.12.2019

[@vinayakpotadar4093]

Nice sir moreover any Idia s for dates converts from text & short cuts more sir.

[@spnn4s106]

wondering if there is a way I can export my outlook calendar into Excel so I can see al my weekly and bi-weekly meetings and make a meeting cadence spreadsheet.
Thank you

[@HaroonKhan-vi6kh]

PK: An Excel Expert
I have different formats of dates in one column some in DMY and some in MDY and secondly some dates are saved as dates and some as text. Please explain how to format it properly. Tnx

[@vamique]

Thank you..

[@PKAnExcelExpert]

Thanks for watching

[@kiranghadi7088]

Can we change multiple column date format at one time using text to column

[@mkitessa]

Helpful thank you!!!!

[@PKAnExcelExpert]

Thanks for your Valuable feedback.

[@srikrishna80]

Hi PK. Love your videos. I am looking for a way to auto populate a calendar when my team updates their appointment in another sheet. My sheet consists of the following data - 1. Customer name 2. Sales status (Each Status has a color code) and next appointment date. When they change a date against a customer, is it possible to auto populate their calendar in that date with the customer name (color coded in the same color as the status)?

[@jackyvivid]

can you tell how to do same in OpenOffice? Where i work they have openoff

[@Excel-power-users]

Hmm nice one

[@Dev_Bartwal]

i have a series of numbers like 1052018,12052018,3052018 these are dates (1-may-2018)..... how to convert to date series of numbers plz help ( text to column is not work properly)

[@muthuraja6589]

Hi bro just try it may be it will working
Column b type date format like 16Nov2018 then click column a ctrl+down arrow then move column b then Ctrl+shift+up arrow Now u press Ctrl+E...you get a ans

[@gauravshakya1783]

any one help for this issue?

[@muthuraja6589]

@@gauravshakya1783 plz mentioned your email id

[@venu09051983]

Apply this formula to your series of numbers
=Text(A1,"##-##-####")
Here A1 is cell number
Now your series of numbers will be converted into 12/05/18
Now copy that cell and paste some where else as paste special 'values'
Then follow above video method

[@venu09051983]

I forgot quotes in above formula
=Text(A1,"##-##-####")

[@braj72]

Thank you

[@PKAnExcelExpert]

Thanks for watching

[@VINAYKUMAR-lo4ci]

Good

[@PKAnExcelExpert]

Thanks

[@omkarkelshikar7484]

Helpful video sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ngujennifer3066]

Pls guide, why when I format my text to date, all turn up as ######### in the cells but when look at the cell formula, its correct. Thank you!

[@sharonvoosa8160]

tq

[@abdoharbi]

good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@BachXuanHien]

good, thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@madhupa577]

Nice

[@PKAnExcelExpert]

Thanks

[@maheshhadke14]

I hv put 11 out of 20 (11/20) but it taks it as date
But I need it as simple 11/20 as number

[@gidovanmastrigt4106]

I need to convert following text " 01 February 2020" to date. Is this possible?

[@oddnumber8149]

he will not answer back

[@SIMRANKAUR-eg7nc]

I don't think anything like this possible. U can do 1 thing though use if then to assign 1 to jan 2 to feb ........ And when no are there use text to column for separating and changing to dates. U can check
channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@ModernPindawale]

Sir English to Hindi main convert krne ke liye Kiya kre

[@leukas723]

I am trying this method but nothing happens.

[@nithikasn]

Dear PK,
I am doing Technical report in Excel
i need to produce a MS-Word report using mail merge at the same time one tap all the excel data should automatically typed in MS-Word report
I tried.But failed .They used some external link/macros.I cannot understand
Please give me your email ID.I will forward the excel sheet & Word report

[@iamdell5544]

Any formula about this

[@Dev_Bartwal]

How to covert 1052028,2052028 in date help bro

[@SIMRANKAUR-eg7nc]

If figures r consistent it is possible I mean 2 digits each for day and months and 4 for years. Extract by text to column and opt width instead of delimited and mark the partition accordingly.

[@SIMRANKAUR-eg7nc]

Search channel "off to office". I accidentally came across it. Handling dates has been beautifully explained there.

[@oddnumber8149]

if you have 2-April-2020 doenst work

[@PKAnExcelExpert]

2-April-2020 is already an excel date format. It will work when your date format is a text according to excel. for example - 02.04.2020 or 02042020

[@ConsulthinkProgrammer]

Text to date:
ruclips.net/video/7uDnF_rHfSM/видео.html

[@durgesh91tomar]

👍

[@PKAnExcelExpert]

Thanks

[@LokeshKumar-vo4fv]

Bhai hindi bol leta to kya ho jata ..

[@hemantkumarbadiger443]

Stick to the point

[@jithujoseph1324]

Thank you so much

[@PKAnExcelExpert]

Welcome

[@ramkumar-cv9hl]

Thankyou

[@PKAnExcelExpert]

Welcome

[@alexrosen8762]

Very good

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@syedabdullah5259]

Thanks a lot

[@PKAnExcelExpert]

Most welcome

[@Crackitacademy]

thanks brother

[@PKAnExcelExpert]

Welcome

[@Raushankumar-de5mr]

Thank you sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@saumyaagrawal9892]

Thanks

[@PKAnExcelExpert]

Thanks for watching

[@ajaykumargupta8504]

Thanks

[@PKAnExcelExpert]

Welcome