text plus date and time

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

Guest

I have a list of names and I want to put those names in a drop down list.
Once someone selects a name from the drop down list I want that name and the
current date and time to populate that cell. Does anyone have any
suggestions?
 
This may be a simple approach, but here goes...

Lets say in cell A2 is your drop list. Format cell B2 for Time, and cell C2
for Date and insert the following formulas.

in cell B2 insert: =IF(A2="","",NOW())
in cell C2 insert: =IF(A2="","",TODAY())
 
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

Data validation list using filtered range 3
How can I populate a drop down list from Data Validation? 1
Test plus date and time 1
Drop down list - how doo I make selection disapear? 4
Filtered drop down list 2
How do I auto populate based on a drop down list? 0
static date and time 2
Filter a Drop List ? 1

Back
Top