How to Convert Any Number Pattern into a Exact Date in Excel? | DATE in EXCEL | #excel

How to Convert Any Number Pattern into a Exact Date in Excel?
In this Video Tutorial we will learn how to use date function in excel in combination with RIGHT, MID and LEFT Function to convert any number pattern into a date in excel. It is going to be very easy tutorial. You Have to Practice it once you learn this tutorial.

#DateFunction
#ConvertNumberToDate
#ExcelDate
#EasyExplain
#ExcelDateTutorial

[shakeelahmad]

Easy to understand the way you teached
Very simple and easy way to share the knowledge 👏👌🎈

[brzozowata]

I was looking for such instruction for a long time and finally, you've been able to solve my problem! thank you so much! it was explained very well, I didn't have any problems to adapt it to my case.

[GyanOnTube]

Very good video akash...very interesting and knowledgeable

[shrikantbadge]

Wow. To be honest, i didnt find this complicated because the way you have explained. Thanks a lot. very helpful.

[rihaanshmattupalli]

I think, in case of date with ".", its simple to use replace function in excel. Just replace "." with "-", then it gets converted into date format. But, thanks for the information with regards to the first situation.

[tarunkumar]

Sir 20220414 iss format ko kaise convert krna hoga please suggest me

[jayantgohil]

Thanks a lot Dude ! You have saved lot of time of mine .

[aamirsaifi]

Sir ek question h 10 party h unme ek party ka name 4 bar aa rha ho ya jayda bar or Hume us party ke samne wale column me mujhe phone number likhna ho bina copy paste ke jitni bar party ka name aaye phone number automatically uske same aa jaye

[ankitgurjar]

Date ko number mey kaise change kr skte hai jaise 01-jan-2022 ko 01012022 .

[imthusan]

Hello!, can you create daily doctor discussion form to keep record of particular patience details with his daily discussion and we can track all his history of discussion even after year in easy way, please do it

[sweetydidi]

Sir agar kisi ka age only year me diya hai to usko dd/mm/yy form me kaise convert karenge? Jaise kisi ka birth year 1991 me ho to usko 01/01/1991 me convert karne ke liye kaun sa formula lagana padega?

[waitforit]

How to change a number like 20190423183143.676Z to YYYY/MM.DD ? i think it has time as well making it difficult for me to change it .Please help

[mshoukath]

How to convert if I directly copy and paste the same format

[AjaySingh-]

This syntax is not working showing #VALUE! Error. What could be the possible cause ???

[satyabratanath]

Sir how to convert date format to number format
Ex.25/10/2022 - 25102022

[kylelim]

Not sure why mine can't change. My pattern is 20190619 but while using =date(right(k2, 2), mid(k2, 5, 2), left(k2, 4)) the out put is 09/12/1924 instead of 19/06/2019. Can u help me?

[waitforit]

Can you please help me know how to convert number to date when it's in this format 20190423183143.676Z

[ashutoshdwivedi]

Thanks Sir, nice but here I want to know in date if "0" Not mention I. E 1/03/2019

[jeffreljoyluceno]

It's better to speak english my friend so we can understant 😁

[anandamirtharaj]

Thank you sir...good info, Could you help getting "20200701091312" -ie 2020/07/01 09:13:12