| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| Can I get the date to fill a cell when data changes in other cell | Excel Discussion (Misc queries) | |||
| How to change data in a cell, based on the date | Excel Worksheet Functions | |||
| removing date data from a cell | Excel Discussion (Misc queries) | |||
| Input Date when data is entered into another cell | Excel Worksheet Functions | |||
Linear Mode
