excel automatically enter date when data entered

[@lokeshsahu4126]

KZbin ME AISA EK BHI CHANNEL NAI JO AAP JAISA FORMULA AUR PRACTICAL SHEET BTA RAHA HO SIR ...........SALAM HAI AAPKO SIR

[@nilaypatel1344]

chal juthhu bolvanu bandh kar

[@MohdArif-pj8gg]

Ma Shaa Allah Jaza kalla khairan Bhai

[@gopikachauhan7596]

Wah sahab Wah,like a good teacher explain everything in best way. Na kisi cheez ko dohraya, na huklana, confidence kabeele tareef.

[@NisarAhmed-oy1tz]

Sir ap ka to andaz he apna he

[@anupdasbaba5359]

when i open this file in another day, the date is changed. I dont want the date to be changed.

[@PREMSAGAR47]

Sir..... Apne bahut kaam ki baat bata di hai. Ek chhoti si request hai. Mai chahta hu ki employee ka naam ya employee no input kare aur uska full details automatically fil ho jay.....Jaise ki abhi apke video me time fil ho raha hai. Thank you Sir.

[@shahabislam4912]

kzbin.info/door/cOsbNCxgUZMPoHEI1w-1RAsearch?query=fees

[@chandrashekhargodbole78]

YE VIDEO BAHUT HI BADHIYA HAI, PAR MUZE 2 SE JYADA COLOMNS KE APPLY KARNA KAISE KARE PLEASE SUGGEST.

[@muhammadshakeel3471]

Assalamualaikum awesome your every work essential work day by day jazakAllah

[@s.n.zeeshan7273]

Thank u so much sir for making this video it is soo useful for me 👍 Thank u so much

[@shahabislam4912]

All the best

[@petsourlife5108]

Next day agar aj ka serial number 50tak gaya fir next day fir se 1 se suru hoga ya new serial number create hoga

[@lokeshsahu4126]

I AM A BIG FAN OF YOU

[@krishangauravshukla7126]

Thanks for this video, this formula has really increased my productivity

[@sajjadahmad-jk2fe]

Bahot Ala

[@AbdullahAlMamun-kw5sv]

It is a very essential formula for every Excel user. Thanks to upload the video. May Allah bless you.

[@shahabislam4912]

You are most welcome

[@e-school100]

assalamualaikum sir ye formulas ki file google drive pe add kr ke use kr sakty hain?

[@FaisalKhan-bm6qp]

Sir ye circular ref ka issu bohut logo ko araha hay muje bhi.may mobile Android use kar raha ho uske waja se to nahi?

[@jawwadcheema5633]

Shahab, how can we make the sequence to start over every time the date is changed?

[@syedirfanuddin6480]

GREAT WORK

[@shahabislam4912]

Many many thanks

[@geekywarrior0x126]

Jazakallah Bhai

[@naveedaamir2347]

There are one or more circular refrences where a formula refers to its own cell directly or indirectly.this might cought them to calculate incorrectly. Ye error araha hy sir g

[@richajain8076]

Yes exactly!! Do you get any solution of it?

[@rajubhaitamilgamer8578]

Same here 😟😩

[@zamaniqbal1898]

@@rajubhaitamilgamer8578 SAME HERE

[@mkheree]

Enable Iterative calculations in Formulas Options

[@zukhan69]

nice and interesting way

[@alafiyazoyeb3248]

would appreciate if you provide your working excel sheet in the description which would save time and efforts of viewers who otherwise have to copy the formulas from the screen..thanks

[@samisuhaib]

Really useful. Thank you so much for your help.

[@saurabhdas7724]

Sir ek formula dikhaiye ki agar specific cell mein koi bhi data entry hoga to latest expiry date mein cell mein date of enrollment + 1year or date of enrollment + 2 years or date of enrollment + 3 years. Please note: pure database mein ek hi expiry date hona chahiye. Agar kisi ko har year koi chiz renew karna ho. Aur Seller har record ko rakhna chahta hai lekin latest payment ke anusar latest expiry date hona chahiye. Sab youtube mein sirf expiry date dikha rahe hai. Mujhe same cell mein purana expiry date hatakar naya expiry date rakhna hai.

[@waqasvlog2734]

Its very good work sir can you plz guide me i apply that formulas but i cant get current day day or next day date plz tell and apply same formula

[@Rk-bh7ru]

Refresh hone par date time change ho jayega sir isme

[@aashishthedevilboy]

THANKS FOR MAKING THIS VIDEO SIR. THIS WILL BE HELPFUL FOR ME

[@uundlasrehman554]

I like your style v nice

[@arshadchowdhury4040]

Is this applicable to excel mobile version too?

[@hasmotullahhossain9023]

sukriya It's very useful

[@shahabislam4912]

Thanks and welcome

[@denishsakariya194]

This formula not working on mobile

[@MilanKumar-rk6iu]

If i edit in column c then date and time will automatically update in column B???

[@moodkn]

Very Well ... Thanks...!

[@shahabislam4912]

Most welcome!

[@fazalhussain1742]

Sir, Sheet Close karne ka baad, jab dobara kholte hen, to time update ho jata he ,,,, ham chahte pichla time update na ho

[@sohailmscit]

Good Work

[@everyone2905]

Alhamdullilah

[@rabiaakterahasan]

Excellent

[@anumrehmat9931]

AoA sr esa format bta dy k name of student ,parants name, month ka nam bi kis date ko fee di hn , ktni fee di hn r voucher number bi show ho esa format bta dy plzzzzzz

[@shahabislam4912]

kzbin.info/door/cOsbNCxgUZMPoHEI1w-1RAsearch?query=fees

[@chandrashekhargodbole78]

VERY NICW FORMULA, BUT WANT TO MORE COLOMNS FORMULA APPLICABLE SO WHAT ? PLEASE SUGGEST. THANK YOU

[@sharma1984ful]

please help us with additional step for change of date n time after we re type in name column on same after few min or next day the date and time need to change . am unable to resolve with the above formula for the same .

[@Adeel-td4ln]

I want the save cell value by time .which formula will work

[@masumbillah4506]

Keya apka ye Formula Google Sheet me Kam karange???

[@naufilprince9709]

Bhai yaar sab bht perfect hai but entery ka jo time h wo automatically chang ho rha h jab entery kr rhe h waja ruk q nhi rha h plz help me

[@richajain8076]

Sir this is not working in my MS Excel it's actually excel 2007 and it is showing something as circular reference problem. What am I supposed to do now?

[@atulshukal4072]

Very good Sir

[@syedikramullah1114]

Amazing ❤

[@shahabislam4912]

Thanks 😄

[@mohdmustqeem7192]

A/A sir Sir yadi hamare paas C ki jagah C or D dono ho or kisi bhi ek m entry ho sakti h tb farmula kya hoga.

[@xyzxzxzcxcxz]

How does it will work on google sheet, plz inform, its urgnt sir

[@aavejshaikh1089]

Sir ye formula sabhi xsel me Kam karenga kya

[@shahabislam4912]

YEs

[@waseemferoze7106]

hello, its not working on my sheet. i have done exactly many times. my office version is 2019. please guide

[@mohammedarif2857]

Same here

[@anumrehmat9931]

mjy bht zrurat hn plz ye sara format kasy bny ka proper treka bta dy

[@ahmadkadiwala1577]

But what when we open the same file second day. Date will be changed

[@SKGOELDELHI]

can we get the color change of related cell when date is entered ( either the date cell ) or it gets tick sign

[@ankitsehrawat8211]

You can do that in Conditional Formatting

[@StopforShop]

Bhai jaan (now) ka formula lagaye aap isiliye curent date bata raha hei agar me previous date me kuchh entry karna chahun to keise date change karenge

[@shahabislam4912]

ye current date format hi dega. iske bger ap direct type kar sakte hen

[@Name260812]

Hi, thanks very nice video. how do I add start of the week date only if I want instead of date?

[@siddiquifaizan8369]

sir, same formula enter krne per date to ara ha lkn (0-jan-00) answer araa hai. plzz helo kro. boht try kiya lkn nhi ho ra hai

[@shahabislam4912]

video thek tarha dekh kr formula lagen js tarha date enter he usi tarha apply hoga

[@frh_astroboy8215]

Please please please can u please tell us how to determine date and time of already entered entries.

[@buntysinghable]

Best things

[@rashimponline1782]

Sir iska time ya date wroung kiyu aa rahi hai. ..today's ki date me aana chahiye na

[@shahabislam4912]

system date set hogi wo enter hogi

[@thoughtsofthedays2683]

Thanks sir 🙏

[@shahabislam4912]

Most welcome

[@hellstech9412]

Cell bar bar refresh ho rhy hai prev data change ho rhi hai ye q?

[@harrymatharoo1969]

Big like.

[@shahabislam4912]

Big thanks

[@anumsehar7703]

Sir agr day b Lana ho automatic

[@qaziabbasi6946]

I am getting a circular reference error. please help

[@riderrishabh1386]

And how to lock or freeze the formulas so that no one can change them ??

[@stephencovrig8373]

Thank you!

[@nareshgabani6974]

एंड्राइड मोबाइल पर माइक्रोसॉफ्ट एक्सेल में ओटोमेटिक डेट एंटर कैसे करें???

[@NirbhaySingh-ep3lp]

Hi it is not working in my sheet my office version is 2019

[@ganeshkurne9489]

Sir I want excel formula If vehicle come in morning 7am and out of factory tommrrow after 12pm showing detention If vehicle come in 12pm after and out of factory tommrrow after 12pm showing no detention

[@nikhilkukde6704]

Maine same method office 16 me try ki lekin date and time nahi aaraha hai.

[@munnakumargond312]

Multiple cells me formula lagaye

[@luckybicantt3523]

VERY NICE FORMULA SIR PLZ ALSO DESCRIBE IN THIS VIDEO IF I ALSO WANT TO ADD DAY IN EXISTING FILE WHEN THE DATE AND TIME IS ENTERED DAY FIELD ALSO ENTERED PLZ DESCRIBE THAT ALSO THANKS FOR SUPPORT

[@sanjaygupta982]

MUJHE DATE OF JOING NIKALNI HAI ATTANDANCE SHEET SE JIS DIN SE WO PRESENT HO.HOW TO DO??

[@मराठीकट्टा-ष7र]

Google sheets me nahi hota hee Piz Help me

[@abcdefghijkl396]

Good

[@shahabislam4912]

Thanks

[@kdkd4133]

no needed to complex the easy formula.

[@luckybicantt3523]

AND OFF LINE WORK IS OK BUT PLZ TELL WHEN I USE IT ONLINE IN ONEDRIVE HOW SHOULD I FORMATE THE DATE AND TIME CELL

[@Adeel-td4ln]

I have a question

[@im_drm]

Libre office calc me kaise kare?

[@shadabkhan3853]

Thank you so much

[@shahabislam4912]

You're most welcome

[@technicalfaraz1518]

Sir date and time ka formula work nahi kar raha please help

[@RajeshGupta-dw7gu]

SIR PLEASE EXPAIN KIJIYE ACHE SE KI KONSA WORD KIS LIYE LGA RAHE HO ESE SAMJH NAHI ATA

[@kumarvagwat8493]

Non automatically update able date and time entry karbake dikhao... Ya To easy hai

[@hamzakazmi1191]

Sir is ma circular reference a ra ha...

[@sandeepnilegaonkar5194]

Date kidher hai sirf time update ho raha hai

[@pradeepanapat2326]

Shown formula is not applicable to Google spreadhsset

[@officialpurpose8300]

Formula For Serial No. Is Returning 0!!! Please Clarify!!!

[@MrHemendrasharma]

I TRIED MANY TIMES BUT CAN'T GET IT RIGHT

[@officialpurpose8300]

Where's Date!!! It's Not Showing!!! What's Formula For Date Functions!!!

[@anoopsinghshakya6382]

Date change hokar 1889 हो jati hai

[@CRAZYMANSCIENCE]

Mobile me work nahi kar raha hai

[@Vinodpawarajinkya]

Bismila Sarkar

[@मराठीकट्टा-ष7र]

Google Sheets me nahi hota hee

[@MrHemendrasharma]

SIR PLEASE WRITE THE FORMULAS

[@bunlong537]

why my excel show in year 1900

[@luckybicantt3523]

IF I ADD AN ERROR SHOWS PLZ HELP

[@kommakirankumar]

Not able to take system date

[@naveedaamir2347]

Not working sir.

[@CihanMotors-v7m]

not working

[@Adeel-td4ln]

Hi