How to Automatically Enter Date & Time After Data Entry In Excel

This is okay but when the date changes then....

Please how can i get this formula?

Please send codes

Grt

Second is not updated why ??

Sir, THANK YOU!

Really helpful sir

Thank you

This is great

Thank you for sharing your knowledge ☺️

Perfect

Circular refrence error in my case

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

Formula didn't see

Hello Sir, It is an excellent video. you are requested to insert the formulas in this video link.

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?

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?

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

In google sheet app?

Thank you👍

You're a genius sir.

thank you
it was very helpful

Good but were i can get formula

How to enter current date and time that should not change after a while ?

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.

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!

Wow,i am in need of the formula

Very knowledgeable

excel: too many arguments for this function

what happens when the date changes to the next day?..

Omg, Just what I needed for my class register !! Thanks Sir.

Thanks👍

Need it with vba

How does that work? I get a circular reference error.

IF I OPEN IT AFTER CLOSING IT THE TIME IS CHANGING

I don’t get the code/ formula. The video is helpful. Please send the formula

I couldn't find the formula
Can you guide me please

Please send me the formula, thanks

Send me formula

Is this possible in android?

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?

Bro u have sound same like me

That was remarkable. Thank you, Sir.

Love this video. Great Job

what i need to remove from the formula if i only need the date without the time ?

Please send the formula

Please send me code

I Signed up the link in the description already but didn't get Email Response back.