Using the 'NOW' function within an 'IF' statement

Hi,

Is it possible to use the NOW function within an IF statement? What I'm trying to do is to insert a timestamp into a cell adjacent to the cell where a user will enter their name. So if I was to enter my name in cell A1, I would like the date and time that it was entered to be added to cell B1.

Is this possible, or should I be looking at this from a different perspective?

Many thanks for your time.

Richard Minns

I have a spreadsheet with the date in the footer with the following format:
January 1, 2007

I'm trying to see if I can incorporate the now() function within a macro so that it automatically inserts the date into the footer with that format. Does anyone know if this is possible? I can't seem to get it to work and I'm not sure if im doing it correctly.

Thanks.

hi,
is it possible to use static date function (i.e., control+; ) within if function
for example if i enter integer in cell in b4 is it possible to get static date in cell c4 if the value in b4 is integer and not fraction.

regards
rao 284562

Does anyone know the asnwer to this?

I am using excel 2007 and I am trying to create a formula that will check to see if one cell is blank and compare a date in another cell to the current date by using the =now() function.

I've structured my formula as follows:

=if(and(e3="",now()>d3), "Send Request", "N")

e3 represents the received date and d3 a due date

Any help would be greatly appreciated. Thanks.