How to Insert Timestamp in Excel When Cell Changes

Показать описание

Learn how to insert timestamps in excel automatically as soon as you enter or update data in a cell.

Please subscribe to our channel @xlpedia

Suppose you want to enter data in column B and want the timestamps in column G. Then apply the following formulas and formats accordingly.
• A1: =IF(B1="","",IF(OR(G1="",AND(ISNUMBER(A1),B1=A1)),A1,B1))
• G1: =IF(AND(B1LessThanGreaterThan"",B1LessThanGreaterThanA1),NOW(),IF(B1="","",G1))
• Column G Format: mmmm d, yyyy hh:mm:ss am/pm

#AutomaticTimestamp #Timestamp #Excel #TimestampExcel #ExcelTimetamp #TimestapGoogleSheets #AutoDateInExcel #ExcelTutorial

Рекомендации по теме

Комментарии

Hi, I am using this timestamp formula for my shared file with other colleagues. I have enabled iterative calculation and changed max iterations to 1, everything looks fine to me. However, I noticed that there are challenges like:
1. My colleagues are still seeing dates with 00-Jan-1900 when they open the file
2. When I opened up after they edited the file, I am also viewing the date 00-Jan-1900 instead of the normal date.
May I know is there any way to fix it?

yeowcharmaine

I’m afraid this doesn’t work with files stored on one drive and accessed by multiple iOS devices running excel for iOS.. it’s annoying and I’m yet to find a solution.
It works fine on a stand alone spreadsheet stored locally and accessed by pc.
I believe this is to do with how excel on the iPad and iPhone update the spreadsheet with the latest data when loading from the cloud. Sometimes a blank cell will be populated with data from the cloud upon loading and at that point the date stamp is written again regardless if there was one in there before because from that sheets formulas perspective it’s just been added into the cell for the first time (albeit by excel loading latest version of the file) even though the original input was a few days prior Ona different device.

MatLampitt

I want the timestamp (G1) to be updated whenever I update the value of A1, is that possible? Currently it only works if I first remove the value from A1, and re-enter a value. But it doesnt work if I direclty change the value of A1

breaksonn

Hello, I need this for an attendance sheet, I need employees to scan a QR code so that I can get the names and timestamps automatically on my sheet, can you help me?

mh