ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How would I put the date that data was put in a cell? (https://www.excelbanter.com/excel-worksheet-functions/133022-how-would-i-put-date-data-put-cell.html)

KB

How would I put the date that data was put in a cell?
 
I have a spreadsheet that requires manual entry. But I want to record and
show the date that data was entered into the cell. So the data entry would be
in A1, but in A2 I want to show the date the data was entered in A1.

JE McGimpsey

How would I put the date that data was put in a cell?
 
See

http://www.mcgimpsey.com/excel/timestamp.html

In article ,
KB wrote:

I have a spreadsheet that requires manual entry. But I want to record and
show the date that data was entered into the cell. So the data entry would be
in A1, but in A2 I want to show the date the data was entered in A1.



All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com