| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering date and time with a formula
I would like to add the date and time data was entered into a specific cell.
For Instance, my formula would be something like: If A1 is populated, enter the date and time the cell is populated into F1. Is that possible? If not, does anyone have any idea how I can gather that information, if I cannot do it with a formula? -- Lady |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Entering date and time with a formula
Sorry - I didn't see my earlier posting of yesterday and thought it had not
posted for some reason. I then found it later. Thank you Biff for responding. I will check it out! Thanks! -- Lady "Lady Success" wrote: I would like to add the date and time data was entered into a specific cell. For Instance, my formula would be something like: If A1 is populated, enter the date and time the cell is populated into F1. Is that possible? If not, does anyone have any idea how I can gather that information, if I cannot do it with a formula? -- Lady |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically entering time and date to an entry | Excel Discussion (Misc queries) | |||
| can a formula add color based on a date and time? | Excel Discussion (Misc queries) | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
| Date and Time Formula | Excel Worksheet Functions | |||
Linear Mode
