[@KAILASHBHATIA-kf4mu]

thank you very much it is very simple and easy to under stand excellent vidoe

[@satmars520]

thanks a lot. This video has solved my problem with date format

[@vganjaneyulu287]

Excellent job sir!
Thanks a lot!

[@SenthilKumar-xs1tc]

Your class is excellent and iam also learning hindhi

[@rupeshg1]

Nice information

[@snp9434]

Good theory and practical....

[@sanatanmishra86]

Thank you so much ....very very happy ...only 2minit main shik geya ...

[@PankajKhede]

Thnx.....my presentation is complete.,

[@ICLCLASSES]

All the best

[@behappymusic7496]

Great bro within few min i got my answer 😇

[@humainfatima3445]

I select DD/MM/YYYY but after selecting day transfer in month and month in day 😢
But pattern is same like this
Eg. DD/MM/YYYY is 04/07/2023 when i choose the format it shows like 07/04/2023 😮😢

[@isakshaikh7348]

Thanks brother very very helpful..

[@subhashreepriyadarshini4311]

Thank you so much

[@najminsultana8066]

দারুন

[@kasulagovardhan968]

very useful information....

[@mrCetus]

Thanks lot. I got what I think since last day's ago 🙏.

[@TariqKhan-gc3pe]

** hi bhot behtareen sir G **

[@pavanthechembull]

Only few dates were changing through this to mm/dd/yy. Rest of the cases remains like MM-DD-YY format only

[@MegaCaptsparrow]

You could be more friendly ..you sound like old school Teacher 😂 but nice one

[@damornarvatp.9605]

Good sir

[@kulvindersinghgollu1756]

bahut ache sir g..very thanks

[@debaprasadmohapatra9235]

Very good tricks....Thanks

[@ICLCLASSES]

Welcome

[@110jaswindersingh]

Good and easy explanation

[@theindian6822]

thanks for help..🙏🙏🙏

[@sheikhasadahmed5886]

Like your way of teaching👍

[@ashokkumura9929]

Very useful video sir

[@FunnyVideos-fp8pv]

Good

[@dheerajkaushik]

Sir ye horizontally row wise apply kaise hoga

[@rythu_king]

If we have different date formats like 24-01-2011 00:00:00 ,23/05/2022 12:00:00 AM how can we dd-mm-yyyy format.

[@taniyaganguly2837]

👍👍

[@reetalgautam366]

very nice video sir thank you

[@mithileshkrray8196]

Nice

[@pankajpankaj-tf4nb]

Super sir

[@yuvrajthakur4983]

Thank you very much sir....that was easy...🙏🏻🙏🏻

[@ICLCLASSES]

Thanku mr. Yuvraj

[@savyamallick998]

excellent..

[@dkentertainment9884]

Formula is very helpful

[@rawaikar1]

Excellent Video

[@priyankasinghpriyankasingh3154]

Thanks a lot
Excellent sir

[@saquibbodu6320]

very nice explain sir

[@pematso4501]

Thank you so much for sharing very helpful things
This is very helpful for me 👍👍👍👍👍👍🌞🌞🌞🌞🌞🌞🌞

[@user-lu3pu6cw4f]

nice

[@jayeshvadhiya3050]

Good job... It was heplful..

[@ICLCLASSES]

THANKU SO MUCH

[@Makstar9335]

Sir kya me ek date likh kar date aur month show kar sakta hun??
Jese mene likha 10
To ye date convert hokar 10-01-2021 me convert ho jaye..
Plz sir tell me....

[@GAURAVYADAV0582]

Wow sir thanks very nice

[@snehadhar5257]

Hi Thanks!
How to change the dates to a single format if the format is mixed in a colums. Eg, 29.9.2010 and 20/7/2019 in the same column, how to get it in one format?

[@udaancomputerclass561]

Hii,
Using text to coloum function your query would be slove
Data tab
Text to coloum
Without change anything click on next
Select date format
Then finish

[@anishalok6548]

@@udaancomputerclass561 what's formula please explain me

[@shaahidkhan8607]

Can we permanently set the date format to indian format ???

[@krishnaguduri6473]

Sab data me - hai aur hame / karne hai aur date serial nai hai tho kya har ek ko edit karna padega

[@kabir2272]

Thnk u respected sir.....for the video

[@ICLCLASSES]

My plzr

[@basanrai9377]

Sir showing my in date's place ####### how do slove

[@mdfazal4725]

Thx Bro..

[@snehachaurasia2716]

29-03-2019 agar hame aisa chahiye hoga toh custom mein jake / ki jagah yeh - dalna hai na ?

[@Brief_Knowledge_01]

In a Excel column, I changed custom date format as MM/DD/YYYY using format cells option. Then I entered date as 29/03/2019 intentionally. But it is not changing as per format applied. could you please help me on this?

[@DEBORAH_JOHNSON]

THANK YOU SO MUCH SIR, THANKS ALOT

[@chiranjeevig8740]

Thank you very much

[@hidayat111999]

ऐसा नहीं मेरे दोस्त। परमानेंटली कैसे चेंज करते हैं ये बताव।

[@skdaveskdave9798]

I want to know the formula if in column have 1,3,4,6,7 wish to convert in side column as Jan,Mar,Apr,Jun,July intimate in hindi

[@udaancomputerclass561]

Sir,
Using text formula this Query would be slove
=Text(cell number,"mmm")

[@Bchand-i3o]

Thank you Sir

[@bjygaming9]

great job

[@Ravi-sharma0052]

Good job

[@ankitbunkar]

👍🏻

[@abdulqadirkhattak7661]

Sir baaz dafa conditional formatting date py apply nahi hoti es ki kya waja hoti hai day ko wo month read krta hai.

[@harshadvarsani5826]

Agar pehle se 01/sep/2022 likhahe aur usko chqange karke 01/09/2022 karna he to keise change kare

[@vijaykumar-gp2ze]

THANKS SIR

[@spverma3886]

Sir is pr datedif ka formula laga kr age count krna

[@soumitramakar9247]

Thank you sir...❤️

[@salman3609]

Same date. Chahiye all column me

[@sweetydidi3515]

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? '

[@MilanKvideos9024]

Thnaks

[@sukhdevlagdhir1475]

By default humko ek list mai Sare logo ka DOB enter karna ho toh kese?
I mean we should only write digits (12122005) and after pressing enter it should change to 12-12-2005

[@hardikkadakia]

=Text(value, "dd-mm-yyyy")

[@RbTvloger]

Sir jaise 23/09/2021 likhne par uper heading me bhi same / wala dikhna chahiye , plz solve

[@manufacturer5953]

Thanks sir

[@gunindradas8042]

Sir I need only month and year format. Ex. 27/08/2019. I need aug.2019 this format

[@udaancomputerclass561]

Hi,
Using text function this would be resolved
=Text(cell number,"mmm")&"-"&year(cell number)

[@naeemurrahman2]

Thanks for ur information but I have a problem with formula bar formula bar Mai alag format hai our nechi alak format hai isko ak jasa kaise Karna hai Zara ye Hal karai plz

[@harshavardhana5907]

Thank you , I am new to excel, Need help !!, when I type this date 29/03/2019 and using the fill handle to drag down, the year changes but not the date or Month, please advise
29/03/2019
29/03/2020
29/03/2021
29/03/2022
29/03/2023
29/03/2024
29/03/2025

[@udaancomputerclass561]

Hii
Use fill function which is given on home tab at editing group
Select coloum
Select date
Select day
Then ok

[@arul1964malar]

Good, Thank you

[@burnsy96]

Do you have an English version?

[@CH-br4rm]

My report list the birthdate as month and day = 0102 and I need to enter a slash in between the month and day 01/02 without excel changing the date. It turns this to 4/29. Can you please help?

[@udaancomputerclass561]

Hii
Using replace function your query would be resolved
=Replace(cell number,3,0,"/")

[@satyamsikarwar4809]

Very nice

[@rjtechp3820]

Thanks solve my prblm

[@rajanishkumar4556]

Sir Muje date ko ek ek box me auto fill karani ho to kaise kare? jaise kisi form me date ke liye 8 box diye hote hai usme auto fill karani hai.

[@Brief_Knowledge_01]

How can automatically change date format in Excel? Means In a Excel column, I changed custom date format as MM/DD/YYYY using format cells option. Then I entered date as 29/03/2019 intentionally. But it is not changing as per format applied. Could you please help me on this?
How do I ristric date format MM/DD/YYYY in Excel? Means suppose if my team enter date as DD/MM/YYYY they should get prompt to update date in MM/DD/YYYY format. Is there any way to do like this?

[@kirandora817]

Thank you bro for you help.

[@ICLCLASSES]

Always welcome

[@virendrakashyap852]

THANKS sir

[@shivamsingh-pr5qo]

Thankyou 👍

[@surendarbamniya9264]

Excle me date dalty hai is formet se 01-02-2020 to date ka formet is trah change 01/02/2020 kiyu hojata ha plz reply me

[@dare_to_DIY_6571]

Please Kai date of birth likhi hui hain unme serial se date serial se month's & serial se years kaise likhe Jaye ? Humne bahut koshish ki per nhi sequence month's & year nhi ata hai? Please tell me

[@rheapeter9709]

Thank you sir!!

[@tejalnetake8128]

Thanks a lot!!!

[@akashparmar4848]

Agar ham date Manually enter na kare or kahi se copy Karke uspe ye formula apply kare to work Kyu nahi Hota sir ji ???

[@vikram114]

Nice sir 👍👍

[@AshishSharma-bo4jm]

these functions does not work in table format, can you help me

[@mahmoodmakkah9282]

Thanks,

[@azamsyeed]

BAYE sab ctrl * f ke vedo bana plees
ona seet ma ager 5 bar name same ho to as hilit kas kar tafsee sa bata

[@rashmimohanty4216]

Really excellent 👍👍👍👌👍

[@sumitwadhwwa12]

Sir mera kaam transport ka hai usme insurance,fitnes,tax ke date exp hone se phle pta chl gya us sel ka clr cha g ho gya aysa krna sikna hai sir

[@sharemarkethackers380]

Thanks Guriji

[@ICLCLASSES]

my plzr

[@DINESHKUMAR-fh9rh]

👍

[@sapiarrahaman9218]

Mobile me Excel sheet me date format kayse change kare

[@deveshupreti820]

how to convert mm-dd-yyyy format to m-d-yy format, anyone can give us formula

[@mdkashif9811]

Main ye sare chij kar ke dekh liya hoon, but date, month same rahta hai or Year change hota hai only. to ab main kya karun (MS OFFICE 2016)

[@kavelidivya9422]

Tq sir..