You can use CNTRL-;
but in a diferent way. Begin by typing:
=IF(A1="yes",DATEVALUE("

and then touch CNTRL-;

and complete the line with:

"),"blank")

The full line will look like:

=IF(A1="yes",DATEVALUE("4/15/2008"),"blank")


--
Gary''s Student - gsnu200779


"Date Less" wrote:

use CTRL key + ; inside a formula to put the static date in B2 If a2 = YES

if(a2="yes",today(),"blank") the date changes I want to replace today() with
CTRL ;