to say frankly i could not get ur question... ur if condition will work but
after entering formula u need to change the format for cell in custom
m/d/yyyy h:mm

then the value will converts into given format..

and it will not update the value(date and time) untill you close and open
the file.


--
Anil showreddy


"Richard" wrote:

I can't remember how I did it before but I add something to the now() formula
to keep the date from changing, can anyone help? If(b2="","",Now()) or some
condition as such once the date is entered it won't change.