Entering date and time with a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time & Date Formulas 7
Date/Time 1
Adding A Date To Adjacent Cell 2
Counting # of Formulas in a column with formulas and entered data 1
Blanking cells with formulas 2
Inserting current date 8
Calculate elapsed time excluding specific timeframe 10
Spurious Formula Omits Adjacent Cells 2

Back
Top