Dear excel(lent) users

I have an actionlist in Excel with a couple of formulas which make it easier
to fill in the specific details.

When I enter something in field B2 a couple of other fields are filled out
automatically by these formula´s, such as the number of the action, or the
date of today. And this is were my question arises.

I have used the following formula:
=if(B2<"";now();"")

The problem is with using now(), that it always fills in the actual date of
today. Meaning tomorrow now() is today+1. So if I look at the sheet tomorrow
it seems that I entered todays activity tomorrow instead of today.

Is there a way to avoid this from happening in a simple way??

Thanks kindly for helping me out in this matter.

Kind regards,

Jay