Hey was wondering if it would be possible to do the following:

Take this formula:
PHP Code: 
=IF(NOW()<=DATEVALUE("9/12/2012"),"",IF(A!E9=TRUE,"P","N")) 
and make it so the DATEVALUE day (in this case 12) came from another cell

Ex) a formula that looked like this:

PHP Code: 
=IF(NOW()<=DATEVALUE("9/=e7/2012"),"",IF(A!E9=TRUE,"P","N")) 
where =e7 registered in the formula as being 12... is there anyway to do this?