S
smonczka
I'm running into a problem with putting a date in a form i'm making.
I want to have todays date populate a cell when the form is opened.
But only once. So if a person opens the form for the first time it
populates todays date... today(). But if they open the form up again
that date will not change. If you use =today() then each time you
open the form up it populates that cell with today’s date.
Any idea's how i can code a cell with today’s date upon creation but
not have it change each time the form is opened.
Thanks for the help,
Steve
I want to have todays date populate a cell when the form is opened.
But only once. So if a person opens the form for the first time it
populates todays date... today(). But if they open the form up again
that date will not change. If you use =today() then each time you
open the form up it populates that cell with today’s date.
Any idea's how i can code a cell with today’s date upon creation but
not have it change each time the form is opened.
Thanks for the help,
Steve