View original (French)

Create a data registration code

Adlo -  
Jean_Jacques Posted messages 1045 Registration date   Status Member Last intervention   -
Hello,

I would like to create a code for data registration. Let me explain: the idea is that when I enter a person's name in A1, a code in the form of (current date and time) is automatically created in A2.
Actually, I need to know the moment of registration of individuals in my database.
I'm not sure if I'm being very clear, but I hope you can help me.
Have a nice day

Configuration: Windows 7 / Internet Explorer 8.0

2 answers

  1.
    Jean_Jacques Posted messages 1045 Registration date   Status Member Last intervention   112
     
    Hello Adlo,

    If your cell "A2" is in date format, you can enter the following syntax:
    =IF(A1<> "", TEXT(NOW(), "mmm dd"), "")

    Which reads: if A1 is not empty, then display the date in text format "mmm dd"; otherwise = ""

    Happy discovering

    Science only finds what has existed since forever.
    REEVES Hubert.
    0