You can't do that without using code.
Ctrl and ; (semicolon) will enter a static date.
Regards,
Alan.
"Richard" wrote in message
...
If C3 has a "0" then I would like for the current date mm/dd/yy in E3
without
having to type it in each time. I've tried the Now() function but it
changes
each day. I'd like for it to remain the same date without changing each
day.