Hi everybody,

Hope someone can help me with a smart solution for my problem:

Each of our customers has an unique customer #. This number is a following number on the last used customer number and the date of creation of the number. For the creation date we cannot use the =today() formula as this alters due time. is there a formula for the following;

When someting is entered in cell B2 can a formula place in B1 a date of creation. So this is the date when something is placed in B2 (and not change due to time)?

Hope someone can help me! Thanks in advance