Hardcode Date based on another cell

[mayoung]

Is it possible to hardcode a date using a formula based on another cell criteria?
Like if A1 does not equal blank B2 equals today’s date mm/dd/yyyy

or can this only be achieved through VBA?

 

[mumps]

Format B2 as "Date" and then place this formula in B2: =IF(A1<>"",NOW(),"")

 

[mayoung]

Can not get this formula to work? Dorsn’t Now() return date and time?

 

[mumps]

Try: =IF(A1<>"",TODAY(),"")

 

[mayoung]

Hey mumps,
The problem with using today is the date will change, it is not hard coded to keep the same date..I already am using one events change so not sure how to do that either with two. I have tried having two event changes and have not been able to make it work yet..

 

[mumps]

Can you post the code for the two events?