How To Lock And Protect Formulas In Excel: ruclips.net/video/yQjosXMTJyI/видео.html How to Hide Formula In Excel: ruclips.net/video/pN9yA6gvWzw/видео.html
I tried so many other (more complicated) ways to do this from RUclips video without success, then I found this method that was so much simpler than the others; and it WORKED !!! Thank you for posting this solution.
Awesome video Sir but when a value is deleted timestamp also gets delete is there a formula so that timestamp doesnt gets remove even though value is deleted in a cell
Why is it the date changes everytime you open the file on another day? Like when you created a file on jan 22, then when you open the file again on apr 3, it will show apr 3 and not jan 22? Any formula to fix this?
Hello Sir ! many thanks for the formula, it is really helpful. However, the formula also automatically updates the date even i have not made any edits to the data entries and just pressing save. Are there any solutions for that, sir?
thanks, but this date will change everyday, mean after 24 hour the cell B1 automatic will change to 6April, so it's doesn't express data entry day. so, if I want this date doesn't change with time what can I do?
Can't see any formula to copy in description??? EDIT: Finally got the formulas, but didn't work. Getting an error on formula 1 and nothing happens on formula 2!
Only problem with this formula is if you type in Column A and enter then it will keep the date but if you delete everything then it will remove the formula. Formula should be edited so no matter what happens in column A...including emptying it then it should not delete formula from col b
It doesn't remove formula unless you remove it by deleting formula cell. There are two ways you can avoid this. One is to use this approach: ruclips.net/video/T2x47gQBp90/видео.html another way is to lock the formula: ruclips.net/video/yQjosXMTJyI/видео.html let me know if you still have problems.
Thanks for the formula 😉. It takes me some time to adjust some cells since I'm using Android excel as beginner. This is effective so far on Android because havent interactive calculation settings on Microsoft office but has circular sign
Hello! I followed exactly how you had the first formula and it did not work. It gave me 1/0/1900 0:00 ... what did I do wrong? I formatted the cells exactly and did the iteration as well
Does it work in google spreadsheets? What's the formula for it? I would need both formulas, the one that does not change and the other one that updates automatically, can you please help?
Why someone will waste his time by doing this ? When next time file will be opened all dates will be changed automatically as u have inerted Now worksheet function.
How To Lock And Protect Formulas In Excel: ruclips.net/video/yQjosXMTJyI/видео.html
How to Hide Formula In Excel: ruclips.net/video/pN9yA6gvWzw/видео.html
I tried so many other (more complicated) ways to do this from RUclips video without success, then I found this method that was so much simpler than the others; and it WORKED !!! Thank you for posting this solution.
Somebody gives this man a medal.
Someday....
Bro you are genius thanks a lot❤
You're most welcome! Glad it was helpful.
Thanks alot.I consider it about two days.
Great!
You're a genius sir.
Thanks for the comment. Please subscribe and be with us.
Awesome video Sir but when a value is deleted timestamp also gets delete is there a formula so that timestamp doesnt gets remove even though value is deleted in a cell
Check this: ruclips.net/video/gY2rC-Zb6qk/видео.html
Thank you so much, now i saved lots of time 👌
You're most welcome
Brilliant 💡 finally have the solution ., thank you
You're welcome!
Amazing, I have some skills but not at this level, your formula is fantastic to add on my project.
Glad you like it! Please subscribe and be in touch
this is genius! thank you!
Glad you like it!
Why is it the date changes everytime you open the file on another day? Like when you created a file on jan 22, then when you open the file again on apr 3, it will show apr 3 and not jan 22? Any formula to fix this?
It works. Try again.
Exactly what I needed! Thank you sir :)
You're welcome!
Thank you for sharing your knowledge ☺️
You're most welcome! Thanks for subscribing.
Thanks man still helping in 2024
Glad you like it. Each video of this channel is working as of today so subscribe and share with your friends.
Thank you bro❤
You're welcome!
Hello Sir, It is an excellent video. you are requested to insert the formulas in this video link.
Check description. Its already linked there.
Hello Sir ! many thanks for the formula, it is really helpful. However, the formula also automatically updates the date even i have not made any edits to the data entries and just pressing save. Are there any solutions for that, sir?
There are two formula. Check the other one.
thanks, but this date will change everyday, mean after 24 hour the cell B1 automatic will change to 6April, so it's doesn't express data entry day. so, if I want this date doesn't change with time what can I do?
Did you try it? Are your sure the date will change? Why don't you try and let me know the result?
Really helpful sir
Thanks a million. Please subscribe and be with us.
Can't see any formula to copy in description???
EDIT: Finally got the formulas, but didn't work. Getting an error on formula 1 and nothing happens on formula 2!
Try again. Follow the instruction carefully. Once the formula 1 works the second one will work too.
Wow,i am in need of the formula
Check the link in the description.
Hello...I signed up, got the sign up form which I did but no formula received. I rechecked and all my info is correct.
Please check Now.
I am looking for a long time ago. Now I see it Thanks
Glad it helped.
Its very userful thanks
You're most welcome.
Please how can i get this formula?
Link in the video description.
I don’t get the code/ formula. The video is helpful. Please send the formula
Code link in the video description. Please check
I Signed up the link in the description already but didn't get Email Response back.
Check now. Check the spam and promotional tab also.
what i need to remove from the formula if i only need the date without the time ?
Just format the column as date.
Only problem with this formula is if you type in Column A and enter then it will keep the date but if you delete everything then it will remove the formula. Formula should be edited so no matter what happens in column A...including emptying it then it should not delete formula from col b
It doesn't remove formula unless you remove it by deleting formula cell. There are two ways you can avoid this. One is to use this approach: ruclips.net/video/T2x47gQBp90/видео.html another way is to lock the formula: ruclips.net/video/yQjosXMTJyI/видео.html let me know if you still have problems.
Sir, THANK YOU!
You are welcome!
Thanks for the formula 😉. It takes me some time to adjust some cells since I'm using Android excel as beginner. This is effective so far on Android because havent interactive calculation settings on Microsoft office but has circular sign
Thanks for sharing your experience.
formula not working for me on google sheet can you help
It doesn't work on google sheet. Sorry.
How to enter current date and time that should not change after a while ?
It doesn't change after a while
Very knowledgeable
Thanks. Please subscribe and be in touch
sir how i get formula please
sir i fill farm but didn't received formal,
Check now.
Next day it will change automatically so how do i make it write only the date of its day not current date
Did you try it?
Thank you for information How can I use formula on mobile !
I didn't use on mobile.
Please please please its a humble req. Can u please tell us how can we determine date and time of already entered entries
Not that i know of. You can get created date, modified date etc. of a workbook not individual entries that is already placed.
Hello! I followed exactly how you had the first formula and it did not work. It gave me 1/0/1900 0:00 ... what did I do wrong? I formatted the cells exactly and did the iteration as well
Please check and match your laptop/desktop time format with the format you are using on your worksheet. Inform me the result.
How does that work? I get a circular reference error.
Yes. Thats why you need to switch on itrative calculation. Check the tutorial again.
Great video and this formula will greatly help me out big time. How do I get the formula?
Visit the site: msexceltutorial.com/post/How-to-Automatically-Enter-Date-and-Time-After-Data-Entry-in-Excel
Thanks dude
Happy to help
Thank you👍
You're most welcome.
it works, but after couple of months, this cell shows #VALUE error...???
Check the itreative calculation settings
Thank you bro, this help me a lot ^^
Glad I could help. Please subscribe and share.
Great , the video is helpful
Glad it was helpful!
In google sheet app?
Nope. Not with this.
This is not working for me. If I have 10 rows of data, all 10 rows will reflect the same date and time. Please advise?
If you need same date and time you need to do that manually. This is created to insert date and time of entry.
I did subscribed and signed up but i have not got the codes
Please check now. Code Sent.
Love this! Very helpful and hoping this works as my team and I update our file.
Glad it was helpful! Please subscribe and share
Thanks bro😇very helpful
Happy to help
This is awesome! Thank you! :)
You're very welcome!
You should keep the formula in description so people can copy
Its there. Check the link.
Super cool! Thank you! Subscribed!
Thanks a million
Is this possible in android?
Nope. Sorry mate.
The first formula works, but the second shows 01/01/1900. Can You help me?
Send me an email. address is in the channel about section.
Thank you
You're welcome. Please subscribe and be with us.
Thank you, very helpful
Glad to hear that!
I couldn't find the formula
Can you guide me please
Link in the description.
Does it work in google spreadsheets? What's the formula for it? I would need both formulas, the one that does not change and the other one that updates automatically, can you please help?
It doesn't work on google sheet. Sorry for that.
how can i get the formula
Signup using the link in the description.
Watch now: How to Enter Date and Serial Number Automatically When data is entered in Excel: ruclips.net/video/gY2rC-Zb6qk/видео.html
Omg, Just what I needed for my class register !! Thanks Sir.
Awesome. Please subscribe for more.
Not sure what im doing wrong, i simply cannot get it.
How about this one then: ruclips.net/video/OOZkRH88Pn4/видео.html
Form showing recaptcha error. Please share the code
Try Now
@@Excel10tutorial Done already, didn't receive any email
Code sent to your email 12 hrs ago. Please check. Also check the spam folder.
@@Excel10tutorial Found it in the spam folder. thanks 👍
Thanks for letting me know.
Thanks for showing an interesting formula which I did not know.
Glad it was helpful!
George khan you give me the code
Abdirahman Saed, Please check this link for the code: msexceltutorial.com/post/How-to-Automatically-Enter-Date-and-Time-After-Data-Entry-in-Excel
Love this video. Great Job
Glad you enjoyed it!
what happens when the date changes to the next day?..
No problem. It will still work.
the problem is: the date is changed while the date of the pc is changing. can it be fixed ? so that the date is not changed
Date function works along with the pc date. So there is nothing you can do.
@@Excel10tutorial THANK YOU
You're welcome
But date will be changed tomorrow, so how to fix the data entry date
Check This: ruclips.net/video/mKUMbCdXWKo/видео.html
That was remarkable. Thank you, Sir.
Glad you enjoyed it!
Thanks👍
You're welcome.
i did not get the formula ,can you send it ?
Sent
Thanx
Welcome
Please send me the formula, thanks
In the description.
Signed up. Havent recieved any mail yet.
Sent
@@Excel10tutorial Got it. But when i type something in cell A1 it gives me a circular reference error. plz help
Follow the video instructions. Enable Iterative Calculation
Circular refrence error in my case
Step 1: Click on the File Tab
Step 2: Click on Options
Step 3: Click on Formulas
Step 4: Checkmark "Enable Iterative Calculation"
Second is not updated why ??
Format your date column
This is great
Thanks a million. Please subscribe and be with us.
Perfect
Thanks. Please subscribe
Why someone will waste his time by doing this ? When next time file will be opened all dates will be changed automatically as u have inerted Now worksheet function.
That's the difference between watching and applying. I wish you had tried it.
you have entered Now formula in your example so if data is entered next day for eg 24052020 will all dates change to 24052020 or only the new entry ?
Date won't change. It will add present date. Only new entry will have the new date. Previous entry will have previous date.
Hello, could you please share me formula?
Code sent to everyone who signed up using the link in the description. If you've done that please check your email now.
How do I get code?
Signup using the link in the description.
This is okay but when the date changes then....
It stays the same unless you change it manually
for some reason this formula stop working
Enable iterative calculation again
Need it with vba
Here you go: ruclips.net/video/T2x47gQBp90/видео.html
IF I OPEN IT AFTER CLOSING IT THE TIME IS CHANGING
Try this then: ruclips.net/video/T2x47gQBp90/видео.html
Pls send me formula; thanks
Here is it: msexceltutorial.com/post/How-to-Automatically-Enter-Date-and-Time-After-Data-Entry-in-Excel
Give m e formula
It not working
Code sent to everyone who signed up. Please check.
Send me the link.. I has subscribed your channel
Thanks for subscribing. Please signup using the link in the description. If you've done that already, please check your email.
i sent an email and you havnt responded...
I respond to every single email. Please check the address. Mail id is in the channel about section.
Please send the formula
Link in the description. Please check. No need to signup.
I need the formula
Here is the code: msexceltutorial.com/post/How-to-Automatically-Enter-Date-and-Time-After-Data-Entry-in-Excel
Its showing...00-jan-00
Format the date column
Bro u have sound same like me
May be we look alike also. Now close your eyes and say thanks for the comment and it'll sound like I'm talking to you. No one had that privilege.
please send me the formula
Sent to everyone who signed up using the link in the description.
MrExellent
Thanks a million
need formula
Signup the form. Link in the description.