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.