ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Entering date and time with a formula (https://www.excelbanter.com/excel-worksheet-functions/115129-entering-date-time-formula.html)

Lady Success

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

Lady Success

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



All times are GMT +1. The time now is 08:17 PM.

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