Create a data registration code
Adlo
-
Jean_Jacques Posted messages 1045 Registration date Status Membre Last intervention -
Jean_Jacques Posted messages 1045 Registration date Status Membre 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
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 réponses
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.
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.